Home » SQL & PL/SQL » SQL & PL/SQL » Can a trigger do a commit?
Can a trigger do a commit? [message #35806] Tue, 16 October 2001 12:36 Go to next message
David
Messages: 110
Registered: November 1998
Senior Member
Hi - I have a procedure that uses a DDL command (create). And this procedure is called by a trigger. However it fails, giving the error 4092 (Cannot commit in a trigger). I realize that DDL commands have auto-commit. Is there any way around it? Please help. Thanks - Dave

----------------------------------------------------------------------
Re: Can a trigger do a commit? [message #35832 is a reply to message #35806] Wed, 17 October 2001 13:09 Go to previous message
palanikarupaiyan@hotmail.
Messages: 18
Registered: June 2001
Junior Member
David ,.... I believe that DDL can not be used in PL/SQLs( triggers).

----------------------------------------------------------------------
Previous Topic: posting to a table of records via HTML
Next Topic: PL/SQL-How to access another database instance?
Goto Forum:
  


Current Time: Thu Mar 28 10:33:37 CDT 2024