SQL Developer doesn't give output with Oracle 10g

Question

I turned on server output using 'SET SERVEROUTPUT ON'. also opened 'dbms output' tab and connected to user. ( in sql developer > view > dbms output > plus sign > connect ) I have installed oracle 10g.

SET SERVEROUTPUT ON;

begin
    dbms_output.put_line('Testing output');
end;
/

I'm getting only 'PL/SQL procedure successfully completed.' as ouput.

( It's duplicate question, but as i'm newbie and not have enough credits to comment on that question. so, ... )

What do you get issuing DBMS_OUTPUT.ENABLE rather than SET SERVEROUTPUT ON? — Barbaros Özhan
– Barbaros Özhan, Commented Sep 18, 2021 at 10:57

thatjeffsmith · Accepted Answer · 2021-09-18 11:30:23Z

1

Latest version of SQL Developer doesn't support 10g.

It mostly works, but one of the things that doesn't is polling for DMBS_OUTPUT.

You need convince someone it's worth the time to upgrade that system.

answered Sep 18, 2021 at 11:30

thatjeffsmith

22.7k6 gold badges44 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Zala Jaydipsinh Over a year ago

its the only option, i guess.

user5683823 Over a year ago

@ZalaJaydipsinh - It is not the only option. You can look for an older version of SQL Developer, one that supports Oracle 10. You can look for other interfaces; or you can work in SQL*Plus. With that said, there are many other reasons to upgrade; the ability to use the latest version of SQL Developer is a good reason, but it probably won't make the top-five or top-ten list.

thatjeffsmith Over a year ago

Any effort spent trying to get dbms output working should PALE in comparison to securing your system by upgrading it to a supported platform/version

Collectives™ on Stack Overflow

SQL Developer doesn't give output with Oracle 10g

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related