Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_output.put_line(5) doesnt generate 5
Hi, Malcolm,
Thanks very much.
After I put "set serveroutput on" before begin, I got the correct result. Thanks.
Grace
Malcolm Dew-Jones wrote:
> Grace Tsai (gtsai_at_bnl.gov) wrote:
> : Hi,
>
> : I expect to execute dbms_output.put_line(5) to print out a letter 5, but
> : it didnt. Here is what I entered:
>
> : sqlplus scott/tiger
> : sql> begin
> : dbms_output.put_line(5);
> : end;
> : /
> : I got "PL/SQL procedure sueccessfully completed."
>
> Assuming this is run from sqlplus, "enable output" has to be turned on,
> that's aproximately the name of a function in the dbms_output package,
> look it up to confirm the name.
>
> Use spool if you want to get the output into a file, (just like any other
> output in sqlplus).
>
>
> --
>
> This space not for rent.
Received on Mon Jan 24 2005 - 12:54:41 CST