Re: Server output not printing

Thanks for the reply.

And it helped - indirectly.

I figured out what I was doing wrong. I am connecting to more than one
databases and it seems that after each connect command I have to put a
'set serveroutput on' command. I wrote a little test script like the
one given below with and without the connect string in to check it
out.

Thank you very much for the reply.

Regards,
Young Seeker


"mcstock" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> you didn't include your code, so there's no way to tell if the
> dbms_output.put_line statement is executing.
> 
> the simplest case is this:
> 
> set server output on size 1000000
> begin
>   dbms_output.put_line('it works');
> end;
> /
> 
> run this to prove that it works, then examine your code to make sure that
> the call to dbms_output.put_line is being executed
> 
> if you still have problems, post your code for assistance
> 
> -- mark stock
> 
> "Young Seeker" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> | Hi,
> |
> | I have a simple pl/sql script and I want to print a line. I'm using
> |
> |
> | dbms_output.put_line('Test');
> |
> |
> | when I run the script, it doesn't print anything on the screen.
> |
> | Any help?
> |
> |
> | P.S. 1. before running the script, i do the following
> |              SQL>set serveroutput on size 1000000
> |              SQL>set feedback on
> |
> |      2. I don't have the script defining any procedure or function. It
> | is just a declare-begin-exception-end block.
> |      3. I've tried to print out any exception, but no exception occurs
> |      4. The script runs fine and does what it is supposed to do. (e.g.
> | i have a couple of bind variables which i am populating in the script
> | - and they have the right values after the script is run.)
> |      5. I tried searching for this on the web and on oracle help and
> | all i could get was the do what I mentioned in P.S. 1. And then 'it
> | should work'. but it doesn't .
> |
> |      Any ideas???
> |
> |      Thanks in advance.