Home » SQL & PL/SQL » SQL & PL/SQL » Triggers In package
Triggers In package [message #185022] Sun, 30 July 2006 02:37 Go to next message
saiphani723
Messages: 36
Registered: July 2006
Location: Hyderabad
Member
Can anybody tell me Is there any possibility to call a database trigger from the packages.

If it is yes. Can u pls give me the hint how to call.
Re: Triggers In package [message #185023 is a reply to message #185022] Sun, 30 July 2006 02:49 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
You cannot put a trigger in a package, but you can call a function or procedure within a package from a trigger.
Re: Triggers In package [message #185105 is a reply to message #185022] Mon, 31 July 2006 00:56 Go to previous messageGo to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

Frank...
What happens if i have a logic as mentioned below:
Inside package i have an insert statement which insert a record into a table t1.
There is an trigger created on t1.
At this case i guess the trigger will get fired, right?

Let me know ur comments on this...


Naveen
Re: Triggers In package [message #185107 is a reply to message #185105] Mon, 31 July 2006 01:04 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Quote:

At this case i guess the trigger will get fired, right?


Right.

My comments - you asked for it: why don't you setup a small test case (use the SCOTT schema) to play with and see what will happen yourself?
Re: Triggers In package [message #185108 is a reply to message #185022] Mon, 31 July 2006 01:06 Go to previous message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

Thanl u Frank
Will do that right now...

Naveen
Previous Topic: Using C++ DLL
Next Topic: can i use union in pl/sql??
Goto Forum:
  


Current Time: Mon Dec 05 05:05:36 CST 2016

Total time taken to generate the page: 0.08355 seconds