Home » SQL & PL/SQL » SQL & PL/SQL » Trigger problem
Trigger problem [message #241642] Wed, 30 May 2007 04:38 Go to next message
juhani
Messages: 7
Registered: May 2007
Junior Member
I make an trigger and it fires before delete.
(Make a copy from deleted rows to an other table)

Trigger compiles fine. When I try to delete rows
from table, I got erromessages:
ORA-04091, ORA-06512 and ORA-04088

Can U help me?

BR K
Re: Trigger problem [message #241644 is a reply to message #241642] Wed, 30 May 2007 04:56 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Google for the error ORA-04091
Re: Trigger problem [message #241715 is a reply to message #241642] Wed, 30 May 2007 08:25 Go to previous messageGo to next message
srmunnangi
Messages: 7
Registered: March 2005
Junior Member

Hi,

Check for Exception handling. Post the code for more analysis.

Thx
Re: Trigger problem [message #241719 is a reply to message #241715] Wed, 30 May 2007 08:35 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No exception handling for 4091, it is a programmation error.

Regards
Michel
Previous Topic: Performance Problem
Next Topic: It is possible?
Goto Forum:
  


Current Time: Tue Dec 06 02:38:37 CST 2016

Total time taken to generate the page: 0.05668 seconds