Re: newbie PL/SQL question

Look up the DBMS_OUTPUT package in the server docs. Compile this package on your server. Then from procedures in sql plus use

DBMS_OUTPUT.putline("whatever");

You need to enable the message buffer for DBMS_OUTPUT prior to use. to do this put a line in your login.sql file that says

set serveroutput on size 1000000;

Using DBMS_OUTPUT is discussed in the book "Oracle PL/SQL Programming" from O'Reilly & Associates.

On 8 Jan 1996 03:12:49 GMT, oracle7_at_pansori.snu.ac.kr (Oracle) wrote:

>When executing SQL Procedure,how to see the output?
>
>That's the case in sqlplus.
>
>Confused..
>
>
> yoon_at_arirang.snu.ac.kr
>
>
>
>
Received on Tue Jan 09 1996 - 00:00:00 CET