TO_UTC_TIMESTAMP_TZ Does Not Support ON CONVERSION ERROR Clause
(Doc ID 2661620.1)
Last updated on DECEMBER 31, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
From the SQL Language Reference, the syntax for TO_UTC_TIMESTAMP_TZ was documented as:
However, when the optional "DEFAULT return_value ON CONVERSION ERROR" is used, an ORA-00907 is returned:
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