Triggers fire when an event occures, they are NOT called explicitely.
The answer is NO. But you can force a trigger fire within a stored
procedure...NOT call it.

Regis



-----Original Message-----
From: Kumar [mailto:[Email Address Removed] 29 August 2003 06:25
To: LazyDBA.com Discussion
Subject: Can I Call a trigger from a Stored Procedure?


Hi,

Can I call a trigger from a stored procedure? - Interview question.

Thanks.
Sgnerd
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************

Oracle LazyDBA home page