Hi Shailesh,

Regis want to say, u need not and can not call a trigger from a
procedure as u can call function/package/prcedure from a another
function/procedure/package... and u can call
procedure/function/package from a trigger...

triggers executable pl/sql blocks...

in triggers we define an eventing condition such as before/after
insert/update/delete...on columns/table then scope we define
scope such as for all rows...then actual pl/sql block where u
write yr set of actions...whenever there is dml occuring as per
the eventing condition this pl/sql block is called and the
changes are carried out in the used objects...

for a dba..triggers means a database trigger where as entry level
developer assumes it as application trigger such as key-next-
item/ key-down..

bye the way remember one thing a listner has to become smarter
than speaker...to read between the lines....

good luck...

Shailesh Paliwal <[Email Address Removed] It will be great if u can explain it by an example.
>
>
> ----- Original Message -----
> From: "Regis Biassala" <Regis.[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed] Sent: Friday, August 29, 2003 3:46 PM
> Subject: RE: Can I Call a trigger from a Stored Procedure?
>
>
> > 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] > Sent: 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 documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to oracledba-
[Email Address Removed] > To subscribe: send a blank email to oracledba-
[Email Address Removed] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> >
> >
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-
[Email Address Removed] To subscribe: send a blank email to oracledba-
[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page