| PROCEDURE CALLED ERROR [message #365404] |
Mon, 27 April 1998 11:47  |
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  |
Frank Naude
Messages: 4580
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
