OUTPUT WINDOW

[rdharmar]

I am using SQL Navigator 3.2 and I have the "server output" checked. When I execute a statement

BEGIN
DBMS_OUTPUT.PUT_LINE('TEST');
END;

I cannot get to see the output. Could you please let me know what other settings I need to turn on.

Thanks

 

[SantaMufasa]

RD,

I'm not a SQL Navigator aficionado, but you can test proof-of-concept from SQL*Plus by logging into SQL*Plus, then executing (and observing the results from) the following:

SQL> set serveroutput on
SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE('TEST');
3 END;
4 /
TEST
SQL>

Let us know if the above does not work, then we have at least ruled out problems with dbms_output.put_line.

Mufasa
(aka Dave of Sandy, Utah, USA @ 22:50 (12Jan04) GMT, 15:50 (12Jan04) Mountain Time)

 

[rdharmar]

I got the message
"procedure successfully completed."

 

[SantaMufasa]

RD,

If that was the ONLY result (meaning that you did not see "TEST" above "procedure successfully completed&quot, then there is a problem with the "SET SERVEROUTPUT ON" command. You can check the setting by entering the command (at the SQL> prompt):

SQL> show all

Among the output will be a line that SHOULD say something like:
"serveroutput ON size 2000 format WORD_WRAPPED".

If it says "serveroutput OFF...", then you need to fix that before you proceed.

Let us know what you find.

Mufasa
(aka Dave of Sandy, Utah, USA @ 23:14 (12Jan04) GMT, 16:14 (12Jan04) Mountain Time)

 

[rdharmar]

Oops. The result did return "TEST" and then "procedure sucessfully completed."

 

[SantaMufasa]

RD,

Then your successful SQL*Plus test confirms proof of concept. If you go back to SQL Navigator 3.2, you will do so with the confidence that the "raw SQL, SQL*Plus, and PL/SQL" work fine. If there is still a problem, then it appears to be with Navigator. If your troubleshooting remains unsuccessful, then I'd log a TAR on Oracle MetaLink (unless other Tek-Tipsters have more troubleshooting ideas).

Mufasa
(aka Dave of Sandy, Utah, USA @ 23:21 (12Jan04) GMT, 16:21 (12Jan04) Mountain Time)

 

[rdharmar]

Thank you for your help.

FYI- I did re-install SQL navigator but it did not help. My co-worker installed it from the same place and it works fine for him.

Thanks for the help.