Re: Oracle Stored Procedure

From: <mpir_at_compuserve.com>
Date: Thu, 28 May 1998 20:04:13 GMT
Message-ID: <6kkfvt$5aj$1@nnrp1.dejanews.com>

In article <6ki1au$ho7$1_at_nnrp1.dejanews.com>, cosmogong_at_my-dejanews.com wrote:
>
> I tried to create a stored procedure using this syntax:
> CREATE OR REPLACE PROCEDURE test_proc AS
> BEGIN
> TEXT_IO.PUT_LINE('Hello!');
> END;
>
> And Oracle says:
>
> 3/4 PLS-00201: identifier 'TEXT_IO.PUT_LINE' must be declared
> 3/4 PL/SQL: Statement ignored
>
> Does anyone know why?
>
> Thanks.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

TEXT_IO is a package in the Forms/Developer suite that is usually run on the client. For a procedure to run on the server, use DBMS_OUTPUT

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 28 1998 - 15:04:13 CDT