how to print DBMS_OUTPUT.PUT_LINE() at oracle database 10g?

Question

I am using sql developer and I have oracle database 10g and DBMS_OUTPUT.PUT_LINE() doesn't print. I have tried every way.

SET SERVEROUTPUT ON;
BEGIN
DBMS_OUTPUT.PUT_LINE('hello');
END;

With this code it only states PL/SQL procedure successfully completed. But it doesn't print hello.

That's for SQL*Plus. Does this answer your question? [Printing the value of a variable in SQL Developer](https://stackoverflow.com/questions/7887413/printing-the-value-of-a-variable-in-sql-developer) — Álvaro González, Feb 03 '20 at 08:53
I think because your database is so old, the jdbc driver won't get your output from the buffer — thatjeffsmith, Feb 03 '20 at 09:34

score 0 · Answer 1 · answered Feb 03 '20 at 08:54

0

Did you turn the output on in the sql developer settings?

Try the following:

View -> Dbms Output
On a new dbms output tab there is a green cross "Enable DBMS OUTPUT for the connection". Click it

answered Feb 03 '20 at 08:54

ekochergin

1

Yes,I've already tried it and it didn't make any changes. @ekochergin. – s250695 Feb 03 '20 at 08:55
Same problem, same result: no change. Any other idea? – Michal J Figurski Aug 02 '21 at 20:03
Hi @MichalJFigurski unfortunalely there is nothing more I can say without you sharing your screen. Perhaps you might try to run code in SQLPLUS to check whether it prints something out at all – ekochergin Aug 03 '21 at 06:01

score 0 · Answer 2 · answered Feb 03 '20 at 13:52

0

You need to activate the DBMS Output screen and then choose the workspace you are working too, click on the PLUS button.

answered Feb 03 '20 at 13:52

Lucas Mouta

2 Answers2