[Solved] Raise statement
No. The block as a whole will get rolled back on failure, but the raise statement on its own does not perform a rollback. For example, this block fails and is implicitly rolled back (exactly as if it was an SQL insert etc): begin insert into demo(id) values(1); dbms_output.put_line(sql%rowcount || ‘ row inserted’); raise program_error; … Read more