PLS-00201: identifier 'TO_UTC_TIMESTAMP_TZ' must be declared (Oracle Database 19.0.0.0.0)
On an Oracle 19c database to_utc_timestamp_tz errors when called directly from PL/SQL:
begin
dbms_output.put_line( to_char( to_utc_timestamp_tz( '2021-05-27T16:10:01.111Z' ) ) );
end;
/
"PLS-00201: identifier 'TO_UTC_TIMESTAMP_TZ' must be declared"
However when called via SQL it works fine.
select
to_char( to_utc_timestamp_tz( '2021-05-27T16:10:01.111Z' ) )
as derp
from dual
Is to_utc_timestamp_tz not available in PL/SQL directly, or is it named differently?
Tagged:
0