Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: I can't OUTPUT to work

Re: I can't OUTPUT to work

From: Marc Weinstock <mweinstock_at_lds.com>
Date: Mon, 06 Mar 2000 17:31:28 GMT
Message-ID: <QXRw4.31$WEg.262193@dca1-nnrp1.news.digex.net>

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 - 11:31:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US