Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Timestamp procedure member variable

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>