Home » RDBMS Server » Server Administration » problem with trigger and commit
problem with trigger and commit [message #370126] Tue, 19 December 2000 09:14 Go to next message
joel wozniak
Messages: 2
Registered: December 2000
Junior Member
Hello,

I wrote a after insert or update trigger using dynamic call (DBMS_SQL), to create a database link, to update a table in the remote database and then drop the datbase link.
The code works (I tested in a procedure), but when the trigger is fired I've got the well known 04092 error (commit forbidden in trigger). The problem is, I have no commit or rollback ion my code.
Does dbms_sql package include commit call ?

Best regards,

Joël.

Report message to a moderator

Re: problem with trigger and commit [message #370193 is a reply to message #370126] Sat, 30 December 2000 03:18 Go to previous message
Vinay Bhatia
Messages: 1
Registered: December 2000
Junior Member
Dear
Becase the create and drop are DDL commands and they have an inbuilt COMMIT functionality, it is bound to bounce back.

So change your design.

Bye...Vinay

Report message to a moderator

Previous Topic: how to pass variables into a sql script
Next Topic: numeric validation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 11:36:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.