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" <mcstockspamplug_at_spamdamenquery.com> wrote in message news:<YP6dnfxI3J1FlFii4p2dnA_at_comcast.com>...
> 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" <cutelittleyoungseeker_at_yahoo.com> wrote in message
> news:840b9a17.0311261200.b9bf66b_at_posting.google.com...
> | 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.
Received on Mon Dec 01 2003 - 15:41:58 CST