Page 1 of 1

Configuration Problem?

Posted: Fri 06 Feb 2009 16:47
by CanUpF1
This has got to be a configuration problem.

I'm brand knew to OraDeveloper Studio and need to test a piece of PL/SQL.

Using the debugger I ran the code, it completed successfully, but I couldn't not see the output generated by the DBMS_OUTPUT.PUT_LINE() function.

I can see the 'Output' Window below the code and after running the procedure I checked the 'General', 'Data' and 'SQL Log' tabs to see the output. Nothing.

On the command line display is controlled by setting SERVEROUTPUT ON. Do I have to do the same thing with this application and, if so, where do I set the parameter?

Posted: Sat 07 Feb 2009 14:24
by CanUpF1
I found the answer.

It is a configuration issue. When you connect to a database there is an option under the Advanced tab that you must check in order for results to be shown.

Posted: Wed 11 Feb 2009 13:17
by Duke
Here is another clue. To setup SQL logging go to Tools->Options->Environment->Output.