SET TRANSACTION in a stored Procedure [message #35884] |
Mon, 22 October 2001 08:19 |
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.
----------------------------------------------------------------------
|
|
|
|
|