DSXchange

Hi All,
We have a requirement to execute an oracle stored procedure which has two input and two output parameters.I am using stored procedure stage with the procedure type "Transform" Transaction Size =0,Checking the option Execute procedure for each row,Transaction ISO= Read Committed.
I am sending the two input values to the parameters through the input link and consuming the output from the output parameters mapped to output columns.The procedure consumes 1 row and should return 1 row.The stored procedure generates new a sequence number after checking some upstream dependent tables but does not commit.I assume that when we select the transaction ISO as read committed ,the stage issues a commit after reading the data(1 row) but the data is not sent to output link and the job is getting hanged.When I checked with DBA he said my userid has created locks on the database.Please suggest if I am going wrong in some option or if my understanding on the Transaction ISO is wrong.Also is there a way to issue commit command from datastage to stored procedure if read committed is not the right option?

The stage simply executes the stored procedure, if you want commits issued you'll need to code that into the procedure itself.

The "Commit" has been written in the procedure and it is working fine now with Transaction Isolation as Read-Only