Home » SQL & PL/SQL » SQL & PL/SQL » SET TRANSACTION in a stored Procedure
SET TRANSACTION in a stored Procedure [message #35884] Mon, 22 October 2001 08:19 Go to next message
abdul
Messages: 18
Registered: May 2001
Junior Member
I am attempting to use the SET TRANSACTION command to use a specific rollback segment. I am having trouble determining if the TRANASACTION is Actually set.

I wrote a stored procedure that does a full insert( From table1 to table2). I place the SET TRANSACTION as the first line in the procedure and after the COMMIT.

I use a simple sql program (prog1) to call the procedure.
My question is when I call this procedure from prog1. will it recognize the set transaction command in the called program.

Another note. I only do one commit in the called program.



----------------------------------------------------------------------
Re: SET TRANSACTION in a stored Procedure [message #35887 is a reply to message #35884] Mon, 22 October 2001 09:37 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use dbms_transaction package to set rollback segment inside pl/sql program.

----------------------------------------------------------------------
Re: SET TRANSACTION in a stored Procedure - Suresh - please explain. [message #35889 is a reply to message #35884] Mon, 22 October 2001 11:14 Go to previous message
Jon
Messages: 483
Registered: May 2001
Senior Member
Suresh:

Can you explain why?

Thanks, Jon

----------------------------------------------------------------------
Previous Topic: Capture Feedback in Procedure
Next Topic: dbms_sql
Goto Forum:
  


Current Time: Fri Apr 03 06:41:23 CDT 2020