Re: Text_IO error - using Oracle Procedure Builder!

Hi -

Try this:

PROCEDURE hello_world IS
BEGIN -- Begin of Procedure
DECLARE

	file_out		text_io.file_type;
	file_name	varchar2(80);
 	my_local_var 	VARCHAR2(25);
BEGIN			-- Begin of Block
 	my_local_var := 'This is a test.';
	file_name :='c:\...\filename1.dat';
	file_out	:=text_io.fopen(file_name, 'W');
 	Text_IO.Put_Line (file_out,'Hello World!');  
 	Text_IO.Put_Line (file_out,my_local_var);
	text_io.fclose(file_out);
END;			-- End of Block
END;			-- End of Procedure

Hope i have not missed anything.

Later !!!

Suresh Bhat
Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com

Adrian Harrison <adrianh_at_globalnet.co.uk> wrote in article <37861fd3.91619682_at_news.globalnet.co.uk>...
> Using Oracle 7.3.4, Oracle Procedure Builder V1.5.6.15.3
>
> Experimenting with the procedure builder & copying a very simple example
out of the manual -
>
> PROCEDURE hello_world IS
> my_local_var VARCHAR2(25);
> BEGIN
> my_local_var := 'This is a test.';
> Text_IO.Put_Line ('Hello World!');
> Text_IO.Put_Line (my_local_var);
> END;
>
> I keep getting the error -
>
> error at line 5, col 2
> PLS-00201:identifier 'TEXT_IO.PUT_LINE' must be declared
>
> I know its probably something very simple but as this is my first attempt
it's not very obvious to
> me!
>
> Any Ideas
>
> Thanks
>
> Adrian Harrison
>
Received on Fri Jul 09 1999 - 17:03:31 CDT