Home » SQL & PL/SQL » SQL & PL/SQL » PROCEDURE CALLED ERROR
PROCEDURE CALLED ERROR [message #365404] Mon, 27 April 1998 11:47 Go to next message
JRODRIGUEZ
Messages: 3
Registered: April 1998
Junior Member
I have a procedure in one database calling a procedure in another database using a database link. When the called procedure attempts to do a rollback or commit or savepoint I get error ORA-02074. Error desc. is a rollback or commit must be done from the parent session.
Is there a way I can get around this?
Re: PROCEDURE CALLED ERROR [message #365422 is a reply to message #365404] Mon, 11 May 1998 09:18 Go to previous message
Frank Naude
Messages: 4569
Registered: April 1998
Senior Member
The master or parent transation is the COMMIT-coordinator. Only that session can decide if the database changes must be committed or rolled back.

Instead of trying to rollback, pass an error back to the parent session so it can do the rollback for you. This can be done with the raise_application_error procedure call.

Cheers
Frank
Previous Topic: Bitmap index creation problem
Next Topic: Re: Buffer limit in DBMS_OUTPUT
Goto Forum:
  


Current Time: Thu Jun 24 23:14:43 CDT 2021