How to get oracle killed exceptions -


i have following structure in stored procedure:

loop try   update record state "1"   make process   update record state "2"   commit  exception   update record state "3" //error ! end end loop

now lets supose there error session kill, or client disconnect, while loop running. how can threat error? try..exception not working. need write "3" state field of record.

you can consider:

loop try   update record state "3"   commit   update record state "1"   make process   update record state "2"   commit  end end loop

so, start setting status "3" , commit. start actual processing. if session killed before process ends, changes since first commit rolled back, status rolled "3". if processing ends successfully, changes commited , status set "2".

i don't understand why set status "1", never visible outside transaction, overwritten "2" before transaction commit.


Comments

Post a Comment

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -

i'm using dynamic linq library , there source code , basic docu , nuget version pm> install-package dynamiclinq i'm trying construct clause involves guids i have tried string "id == @0" . parameter array object[] value ( guid xxxx ) var whereclausesb = buildlogicalkeywhereclause2(entity, logicalkey); //build string var parms = buildparamarray(entity, logicalkey); // object[] var wherelambda = ofsi.bos.core.dynamicexpression.parselambda<t, bool>(whereclausesb.tostring(),parms); //parse an exception thrown in dynamicexpression.parselambda operator '==' incompatible operand types 'guid' , 'guid' i have tried guid , string.(fail) i tried , "id = @0" (fail). string == string works, int32==int32 not guid == guid not any ideas? try using equals method instead of == operator in string: "id.equals(@0)"
Read more