SQL> CREATE OR REPLACE PROCEDURE CompileError AS
2 myDateTime timestamp;
3 BEGIN
4 SELECT systimestamp INTO myDateTime FROM dual;
5 DBMS_OUTPUT.PUT_LINE(myDateTime);
6 EXCEPTION
7 WHEN OTHERS
8 THEN
9 DBMS_OUTPUT.PUT_LINE(SQLERRM);
10 END;
11 /
Procedure created.
SQL>
SQL> exec compileerror
26-OCT-09 10.40.32.605000 AM
PL/SQL procedure successfully completed.
SQL>