Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Stored Procedure
A copy of this was sent to cosmogong_at_my-dejanews.com
(if that email address didn't require changing)
On Wed, 27 May 1998 21:41:50 GMT, you 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
>
text_io is only available in client side pl/sql (environments like FORMS for example that have their own pl/sql interpreters).
on the server you can either use:
dbms_output -- to write to the console in sqlplus or svrmgr utl_file -- to write to OS files on the server.
>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
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed May 27 1998 - 20:21:36 CDT