Welcome Guest, Not a member yet? Register   Sign In
[Ask]Managing Rollback
#1

[eluser]Siregar[/eluser]
can i roll_back my transaction although trans_status is true?

my case is like this.,
i success in insert and update two table for example,
but because total_rows of selecting data from tableC is null.,the transaction that have success before must be rollback.

I want to insert data from 2 file, if there is something error while processing second file, including null while selecting data ,the first file that success in insert must be rollback.

Whereas in my observe, the transaction will not rollback if trans_status is true, although we call trans_rollback(); method.

i'm so sorry for my bad English. Thank's in advance.
note: i use db oracle.




Theme © iAndrew 2016 - Forum software by © MyBB