Home » SQL & PL/SQL » SQL & PL/SQL » Cacading Triggers
Cacading Triggers [message #286841] Mon, 10 December 2007 03:53 Go to next message
amit.navapara
Messages: 5
Registered: December 2007
Location: Bangalore
Junior Member

How can we know the number of cascading triggers defined on a object. There is some parameter which indicates this, but want to know the exact name of that parameter...

[EDITED by LF: fixed font size]

[Updated on: Mon, 10 December 2007 05:07] by Moderator

Report message to a moderator

Re: Cacading Triggers [message #286842 is a reply to message #286841] Mon, 10 December 2007 04:04 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

http://
download-uk.oracle.com/docs/cd/B13789_01/appdev.101/b10795/adfns_tr.htm


from the doc :

Quote:

Oracle Database allows up to 32 triggers to cascade at any one time. However, you can effectively limit the number of trigger cascades using the initialization parameter OPEN_CURSORS, because a cursor must be opened for every execution of a trigger.



regards,
Re: Cacading Triggers [message #286856 is a reply to message #286841] Mon, 10 December 2007 04:41 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no way to know the number of cascading triggers defined on a object

Regards
Michel

[EDITED by LF: fixed font size]

[Updated on: Mon, 10 December 2007 05:07] by Moderator

Report message to a moderator

Previous Topic: using in() function
Next Topic: retrieve data without symbol '(single quote)
Goto Forum:
  


Current Time: Sat Dec 10 18:21:39 CST 2016

Total time taken to generate the page: 0.13759 seconds