savepoint never eastblished -- ORA-01086: savepoint 'CREATE_DEBRIEF' never established
Problem Description
---------------------------------------------------
I have a code which is returning me the said error --. ORA-01086: savepoint 'CREATE_DEBRIEF' never established Please can you advice,since I am not finding ny thing wrong here.
We thought our procedure probably did a COMMIT before the ROLLBACK TO CREATE_DEBRIEF instruction. There are a couple of APIs called, so needed to make sure they don't commit otherwise the SAVEPOINT is useless. We had a look into the Csf_Debrief_Pub.create_debrief and see that a commit is indeed used in Csf_Debrief_Pub.create_debrief(see attached,where I have highlighted the Commit statement).
---------------------------------------------------
I have a code which is returning me the said error --. ORA-01086: savepoint 'CREATE_DEBRIEF' never established Please can you advice,since I am not finding ny thing wrong here.
We thought our procedure probably did a COMMIT before the ROLLBACK TO CREATE_DEBRIEF instruction. There are a couple of APIs called, so needed to make sure they don't commit otherwise the SAVEPOINT is useless. We had a look into the Csf_Debrief_Pub.create_debrief and see that a commit is indeed used in Csf_Debrief_Pub.create_debrief(see attached,where I have highlighted the Commit statement).
0