Home » SQL & PL/SQL » SQL & PL/SQL » Trigger in Package (10 i)
Trigger in Package [message #334654] Thu, 17 July 2008 10:28 Go to next message
dheuschkel
Messages: 14
Registered: March 2007
Junior Member
Hi!

I would like to know, if it is possible to create a trigger in a package. And if, how the trigger fires.

Thank you in advance

Dagmar Smile
Re: Trigger in Package [message #334656 is a reply to message #334654] Thu, 17 July 2008 10:31 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

visit http://tahiti.oracle.com

The answers can be found by Reading The Fine Manual below;
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm

Re: Trigger in Package [message #334669 is a reply to message #334654] Thu, 17 July 2008 11:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: Trigger in Package [message #334739 is a reply to message #334669] Thu, 17 July 2008 15:49 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
... but you might create a procedure within a package and call it from a trigger.
Re: Trigger in Package [message #334833 is a reply to message #334654] Fri, 18 July 2008 05:04 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Technically, you cold create a trigger from within a package using dynamic SQL, but there is no reason on earth why you would do that.
It would be a terrible piece of design. The only time it would work without causing a serious performance problem and compromising the quality of your data is if you were the only user accessing a table, in which case you don't need the trigger, as you can just get your code to insert the correct data into the table to start with.
Previous Topic: Warning: PROCEDURE created with compilation errors. missing Select Key Word
Next Topic: Prcedure created with Compilation error
Goto Forum:
  


Current Time: Mon Dec 05 11:15:32 CST 2016

Total time taken to generate the page: 0.05574 seconds