Skip to Main Content

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

if you look at examples you'll see following statement before getConnectionon...

java.lang.Class.forName ("oracle.jdbc.OracleDriver");

Philip

Gell�rt-Oracle

That line was missing from the second example. However my problem is infrastructure related:

java.lang.Class.forName ("oracle.jdbc.OracleDriver"); --->Wrapped java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver

I used Data Modeler 4.0.0.825. This could be related to the custom java home used by my installation.

The same code works with version "3.3.0.747 jre included"

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

Post Details

Locked on Aug 21 2017
Added on Jul 12 2017
10 comments
15,994 views