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
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
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 Jun 17 22:20:15 CDT 2021