"Define Timestamp" Shows Different Result From SQL Developer and SQLPLUS
(Doc ID 1664020.1)
Last updated on MAY 27, 2023
Applies to:
Oracle SQL Developer - Version 3.2 and laterSQL*Plus - Version 11.2.0.3 and later
Information in this document applies to any platform.
Symptoms
Scripts containing "Define timestamp" as
DEFINE <variableName> = timestamp '2014-04-01 00:00:00';
Which is required for a scheduled job, Is developed and tested fine on SQL Developer.
However when running same script from SQL*Plus, it throws exception
Error: ORA-00904: "TIMESTAMP": invalid identifier
Changes
Scripts working at SQL Developer now moved to SQL*Plus
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |