I have searched quite extensively on how to output messages in Oracle SQL. I have read a lot about dbms_output.put_line and dbms_output.get_line and tried using both but am unable to get either to work. Using Oracle SQL Developer Version 2.
Asked
Active
Viewed 4,354 times
4
-
3Oracle 2 was [released in 1979](http://en.wikipedia.org/wiki/Oracle_database#Corporate.2Ftechnical_timeline). – Branko Dimitrijevic Mar 05 '12 at 21:16
1 Answers
4
I'm not sure what application you're using, but, in general, to output the DBMS_OUTPUT buffer to your client, you first need to issue a SET SERVEROUTPUT ON.
Tebbe
- 1,372
- 9
- 12