exec dbms_output.put_line('Your string here')
And guess what, nothing shows on SQL Developer:
As it turns out, the SERVER OUTPUT must be set to on. It's off by default. Nothing is simple enough if Oracle can complicate it, right?
Run the following command:
SET SERVEROUTPUT ON;
exec dbms_output.put_line('Your string here')
You can create a script with SET SERVEROUTPUT ON; and set it as your start up scrip in Tools\Preferences\Database, so everytime you connect to a server, the serveroutput is set to ON.
Check out my new book about R Language http://www.amazon.com/dp/B00SX6WA06
You can also go to View > DBMS Output
ResponderExcluirAnd then add your connection and listen for output
That's right, it's another way to do it!
Excluir