Home » RDBMS Server » Server Administration » problem with trigger and commit
problem with trigger and commit [message #370127] Tue, 19 December 2000 09:18 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 #370133 is a reply to message #370127] Tue, 19 December 2000 17:27 Go to previous messageGo to next message
mekala
Messages: 2
Registered: December 2000
Junior Member
create & Drop database link are DDL stmts.
Oracle issues an implicit COMMIT before and after DDL statement.

Report message to a moderator

Re: problem with trigger and commit [message #370135 is a reply to message #370127] Wed, 20 December 2000 05:39 Go to previous message
Kannan
Messages: 29
Registered: September 2000
Junior Member
the problem is that u create a database link which is nothing but a ddl statement so automatically commit occurs

Report message to a moderator

Previous Topic: Recod not accessable for other users
Next Topic: Two Procedures calling each other
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 00:27:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.