Re: Server output not printing

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 Wed Nov 26 2003 - 14:14:53 CST