Re: Oracle Stored Procedure

From: <jtesta_at_my-dejanews.com>
Date: Thu, 28 May 1998 11:25:28 GMT
Message-ID: <6kjhj8$o2g$1@nnrp1.dejanews.com>

Isn't text_io a forms thing?, you cant use forms functions/procs on the server side for a stored procedure. i think you want dbms_output.put_line('Hello'); instead.

joe
http://www.oracle-dba.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
>

-----== 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 - 06:25:28 CDT