Re: I can't OUTPUT to work

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 07 Mar 2000 03:17:44 GMT
Message-ID: <38cd6fb8.19371124@netnews.worldnet.att.net>

Are you certain that you executed SET SERVEROUPUT ON before executing the procedure? Your note implies that you did, but the fact that you didn't see any output makes me wonder. I was able to compile your procedure and see output. I did have to get rid of the "ME", and I had to pass a string argument in the execute command.

SQL> CREATE OR REPLACE PROCEDURE SP_TEST (nothing IN VARCHAR2) IS
  2 BEGIN
  3 DBMS_OUTPUT.ENABLE(1000000);
  4 dbms_output.put_line('Hello World');   5 END;
  6 /

Procedure created.

SQL> 
SQL> set serveroutput on
SQL> execute sp_test ('yadda');

Hello World

PL/SQL procedure successfully completed.

On Mon, 06 Mar 2000 17:31:28 GMT, "Marc Weinstock" <mweinstock_at_lds.com> wrote:

>
>CREATE OR REPLACE PROCEDURE "ME".SP_TEST (nothing IN VARCHAR2) IS
>BEGIN
>DBMS_OUTPUT.ENABLE(1000000);
>dbms_output.put_line('Hello World');
>END
>/
>
>set serveroutput on
>execute sp_test
>
>
><Sean_at_kewi.net> wrote in message news:8a0p1s$gp$1_at_nnrp1.deja.com...
>> I exec the Stored Procedure and get nothing but a PL/SQL procedure
>> successfully completed. Can anyone please help?
>>
>> --------
>> CREATE OR REPLACE
>> PROCEDURE "ME".SP_TEST
>> (nothing IN VARCHAR2)
>>
>> IS
>> BEGIN
>> dbms_output.put_line('Hello World');
>> END
>>
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
Received on Mon Mar 06 2000 - 21:17:44 CST