Skip to Main Content

SQL Developer for VS Code

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!

Compile Package - Script Output blank

SCronjeApr 24 2025 — edited Apr 24 2025

V. 25.1.0

Login script (login.sql) linked in settings:

set serveroutput on size unlimited
set timing on 
set pagesize 99
set linesize 132

When opening a package using connection explorer and compiling the package/body it works and shows script output as expected. However when opening a view or table using the explorer and then opening the sql tab as below (Pic.1), then moving back to package and compiling the package no script output is displayed. I then have to open a separate sql worksheet and run

alter package <package> compile 

to see any error messages.

Pic.1

I had a look at the trace log, however it's contains a lot of information. I can see it references the login script, but seems to stop working when opening the SQL tab of an object but nothing I was able to identify in the log.

Thanks,

Shaun

Comments
Post Details
Added on Apr 24 2025
1 comment
188 views