• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Ask]Managing Rollback

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.

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.