Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT *
  FROM USER_PROCEDURES
  WHERE PROCEDURE_NAME IN ('P3', 'P4');
-- creates only procedure p3 and exits with no error
BEGIN

  EXECUTE IMMEDIATE 'create or replace procedure p3 is begin null end;'; -- compilation error (missing semicolon)
  EXECUTE IMMEDIATE 'create or replace procedure p4 is begin null; end;';

  dbms_output.put_line('Done!');

END;
/
ORA-24344: success with compilation error
ORA-06512: at line 4

SELECT *
  FROM USER_ERRORS;


NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
ATTRIBUTE
MESSAGE_NUMBER


P3
PROCEDURE
1
1
28
PLS-00103: Encountered the symbol "END" when expecting one of the following:

   ;
The symbol ";" was substituted for "END" to continue.

ERROR
103


SELECT *
  FROM USER_PROCEDURES
  WHERE PROCEDURE_NAME IN ('P3', 'P4');
-- creates only procedure p3 and exits with no error
DECLARE
  eCompilation_error EXCEPTION;
  PRAGMA EXCEPTION_INIT(eCompilation_error, -24344);
BEGIN

  EXECUTE IMMEDIATE 'create or replace procedure p3 is begin null end;'; -- compilation error (missing semicolon)
  EXECUTE IMMEDIATE 'create or replace procedure p4 is begin null; end;';

  dbms_output.put_line('Done!');
EXCEPTION
  WHEN eCompilation_error THEN
    DBMS_OUTPUT.PUT_LINE('Compilation error: ' || SQLERRM);
  WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('Generic error: ' || SQLERRM);
END;
/
1 rows affected

dbms_output:
Compilation error: ORA-24344: success with compilation error

SELECT *
  FROM USER_ERRORS;


NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
ATTRIBUTE
MESSAGE_NUMBER


P3
PROCEDURE
1
1
28
PLS-00103: Encountered the symbol "END" when expecting one of the following:

   ;
The symbol ";" was substituted for "END" to continue.

ERROR
103


SELECT *
  FROM USER_PROCEDURES
  WHERE PROCEDURE_NAME IN ('P3', 'P4');