SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Dev 20.2 raises error for SYS_EXTRACT_UTC call

Danno_AECCJul 10 2020 — edited Jul 10 2020

Hello all,

Here's a weird problem. I upgraded from 19.4 to 20.2 and now have an issue with function call SYS_EXTRACT_UTC. The previous versions in use with other folks at my company that currently have no problem are 4.1.5.21 (wow, eh?), 18.1, 19.3, and 19.4. I have no idea what to look at to resolve this problem but we use timestamp with timezone extensively and I'm handicapped for troubleshooting code right now.

SQL*Plus example (to show code):

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select sys_extract_utc(to_timestamp(trunc(sysdate -3))) from dual;

SYS_EXTRACT_UTC(TO_TIMESTAMP(TRUNC(SYSDATE-3)))

---------------------------------------------------------------------------

07-JUL-20 05.00.00 AM

SQL>

Success with 19.4 :

SQL Dev success with SYS_EXTRACT_UTC.jpg

Failure with 20.2 :

SQL Dev failure with SYS_EXTRACT_UTC.jpg

The error in 20.2 :

ORA-00904: "SYS"."SYS_EXTRACT_UTC": invalid identifier

00904. 00000 - "%s: invalid identifier"

*Cause:

*Action:

Error at Line: 17 Column: 8

Any advice on what to do here?

Thanks,
Danno_AECC

This post has been answered by Glen Conway on Jul 10 2020

Jump to Answer

Added on Jul 10 2020

#sql-developer

2 comments

293 views