SQL Developer for VS Code

hello @all,

The execution of the SQL statement
select * from sys.all_tables where owner = 'SYS';
is crashing when run as a user with the DBA role.

However, it runs smoothly without the DBA role.

executed statements in VS Code … trace file is attached

select
    sys_context('USERENV','CLIENT_PROGRAM_NAME') CLIENT_PROGRAM_NAME
from dual;

LIENT_PROGRAM_NAME
----------------------------------------------------
Oracle SQL Developer for VS Code/25.3.0


select username,granted_role, default_role  from user_role_privs;

USERNAME              GRANTED_ROLE                                                                                                                     DEF
--------------------- ----------------------------------
DEMOUSER              DB_DEVELOPER_ROLE                                                                                                                YES
DEMOUSER              DBA                                                                                                                              YES


select * from sys.all_tables where owner = 'SYS';

-- crash
-- DBTU-05002: An unexpected error occurred during processing of task 
-- check trace.log

have fun

Markus

trace.log