How to Create Rollback & Savepoints on Oracle apex?

Question

Is there any way to Create a save-point and to Rollback on Oracle apex application I have tried several times on Application but several error occurs

Littlefoot · Accepted Answer · 2020-06-19T05:10:04.427

2

Code should be complete; you can't have only begin and savepoint. Something like this:

begin
  savepoint a;
  delete from test;
  rollback to a;
end;
/

Your code, fixed (you must terminate every statement with a semi-colon ;):

begin   
  savepoint a;
  UPDATE emp SET salary = 70000 WHERE ename = 'HUzaifa';
  rollback to a;
end; 
/

edited Jun 19 '20 at 05:10

answered Jun 18 '20 at 20:33

Littlefoot

semi colon after "rollback to a;" – Koen Lostrie Jun 18 '20 at 20:59
`begin savepoint a UPDATE emp SET salary = 70000 WHERE ename = 'HUzaifa' rollback to a end; ` Like this ? @Littlefoot @Koen Lostrie @littlefoot It still doesnt work – Sharjeel Sohail Jun 18 '20 at 21:03
You have to terminate statements with a semi-colon. Have a look at my answer which contains your code, fixed. – Littlefoot Jun 19 '20 at 05:10

1 Answers1