SET ECHO OFF SET VERIFY OFF SET SERVEROUTPUT ON WHENEVER SQLERROR EXIT 1 BEGIN Insert into tab (id) ( With a as (select level a from dual connect by level <= 4), b as (select level b from dual connect by level <= 6) select 'A'||to_char(a,'fm00')||'B'||to_char(b,'fm00') from a,b); commit; EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('FAILURE: ' || SQLERRM); ROLLBACK; RETURN; END; /