Configuration Problem?

CanUpF1 · Post by **CanUpF1** » Fri 06 Feb 2009 16:47

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?

CanUpF1 · Post by **CanUpF1** » Sat 07 Feb 2009 14:24

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.

Duke · Post by **Duke** » Wed 11 Feb 2009 13:17

Here is another clue. To setup SQL logging go to Tools->Options->Environment->Output.