Re: Writing to a file on the client

TEXT_IO can only be accessed and used from Oracle Forms. SQL*Plus is a server side interface, thus cannot see it. Use UTL_FILE for SQL*Plus. Also, Procedure Builder accesses server side stuff and is the same for that.

The 'procedure builder' in Oracle Forms should be able to use TEXT_IO fine.

HTH, Mark

"Brian Potter" <potterrb_at_mediaone.net> wrote in message news:<2w9G7.6154$PM1.77208_at_typhoon.mw.mediaone.net>...
> This looks like it should work, but when I try to use TEXT_IO I get an error
> message. Specifically, the declaration
>
> my_file TEXT_IO.FILE_TYPE;
>
> produces the error "PLS-00201: identifier 'TEXT_IO.FILE_TYPE' must be
> declared", both in SQL*Plus and Oracle Procedure Builder. In Procedure
> Builder, I can see the built-in package TEXT_IO.
>
> Any ideas?
>
> Thanks,
> Brian
>
Received on Thu Nov 08 2001 - 09:36:56 CET