FREE AI-Enhanced Online Oracle PLSQL Compiler

SQL Fiddle

During Phase 1, only users who are logged in can access the AI Editor feature.

SQL Fiddle is free to use and ad-free!

Want to help us? It takes 10 seconds

Step 1: Like & Share our EFE Bulk Extensions videos

Step 2: Like & Share our EFE Bulk Insert videos

Thank

Under Development!

Fiddle History is not yet available.

We hope to make this feature available at the end of 2024.

Untitled*

You must execute the code again to save those values in the database.

xxxxxxxxxx
 
declare
  e_sql_cancelled exception;
  pragma exception_init(e_sql_cancelled, -01013);
begin
  raise e_sql_cancelled;
exception
  when e_sql_cancelled then
    for a in ( select 'my value' as value from dual t ) loop null; end loop;
    raise_application_error(-20001, 'My error', false);
end;
/

declare
*

ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 8
ORA-06512: at line 8
ORA-01013: User requested cancel of current operation.
ORA-06512: at line 5