Skip to Main Content
Forums

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 Developer 17.2 doesn't show DBMS Output

andre_dJul 12 2017 — edited Jul 24 2017

Hi,

I am testing version 17.2 of SQL Developer and have stumbled across this problem:

SQL Developer does not display the DBMS server output, neither in the connected DBMS Output window nor in the Script Output window.

To test I used the following code in a regular worksheet:

set serveroutput on;

begin DBMS_OUTPUT.PUT_LINE('this is dbms_output speaking'); end;

The DBMS Output window shows nothing, the Script Output window just outputs that the script ran successfully.

On the previous version of SQL Developer ( Version 4.2.0.17.089, Build 17.089.1709) this works as excpeted, showing the text in both windows.

I am using:

- SQL Developer (Version 17.2.0.188, with JDK included)

- Windows 7 Enterprise with German region settings

- Oracle 10g database with german NLS

Is this a bug or am I missing some sort of configuration option?

Regards, André
This post has been answered by Gary Graham-Oracle on Jul 18 2017
Jump to Answer

Comments

thatJeffSmith-Oracle

I don't see any issues in my setup.

Win7, connected to 12c database running on Oracle Linux

Version 17.2.0.188

dbms-output172.png

dz_r

I have the same problem when I'm connected to database 10g.

With database 12c it works.

1 person found this helpful
thatJeffSmith-Oracle

does v4.2 work with your 10g db? and exactly what version of 10g?

Andris Perkons-Oracle

Hi,

I can confirm that 4.2 works with 10g (unpatched 10.2.0.1 on Solaris x86), whereas 17.2 does not.

11g, 12c -> no problems.

Andris

dz_r 
thatJeffSmith-Oracle napisał(-a):
does v4.2 work with your 10g db? and exactly what version of 10g?

SQL Developer 4.2.0.17.089 works fine with database 10g.

New SQL Developer 17.2.0.188 works with:

- Oracle Database 12c Standard Edition Release 12.1.0.2.0

- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

and doesn't work with:

- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0

andre_d

Using Oracle DB 10.2.0.5.0 Standard Edition on Linux x86 64-bit here.

SQL Developer Version 4.2.0.17.089 works

SQL Developer Version 17.2.0.188 does not

thatJeffSmith-Oracle

You'll need to log an SR with MOS on this. I'm assuming you have an extended support contract on 10g since it's about 7 years old.

andre_d

Unfortunately we don't have extended support for that database, so I can't log an SR. But the db will be updated soon, so I don't worry.

But just for my understanding: since the 10.2. database version is out of regular support, it is also not "officially" supported by SQL Developer anymore, only via Extended support?

Gary Graham-Oracle
Answer

As explained in http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf even extended support for 10g expired in July 2013, and any follow-on sustaining support does not include new patches for the database itself, but might get you a SQL Developer fix in a patch or upgrade.  I say "might" since one possible resolution status for a bug is "NOT FEASIBLE TO FIX".

You should also note, due to dependencies with other components in the Oracle stack, that a fix or workaround might not be found only in the database or the application.  Here is a case involving 10g and 17.2 where the workaround is to avoid using older versions of the JDBC driver:

So, in your case, it may possibly make a difference whether you use the default JDBC driver (12.2.0.1) shipped with 17.2, or a previous driver (potentially as old as 11.2.0.3).    

Marked as Answer by andre_d · Sep 27 2020
andre_d

Gary, thanks for the explanation.

I will give changing the JDBC driver a try if I have the time.

1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 21 2017
Added on Jul 12 2017
#sql-developer
10 comments
16,013 views