Re: How to open a file within a stored procedure??

You can try TEXT_IO.FOPEN

Ganga

Gerrit-Jan Linker wrote:
>
> Hi,
>
> One solution may be the following (not very beautiful though...)
>
> You can have a program running on your box which is connected to a database
> pipe. You post a message in the pipe to make the program read the file and
> send it's contents, via the pipe, back to Oracle.
>
> Regards, Gerrit-Jan Linker
> Developer of Oraxcel, OraCodes, OraWeb and OraSQL
> http://members.aol.com/gjlinker
>
> >I am using Oracle 7.2.3 which does not support the UTL_FILE package. But I
> >need to open a file to read its content in one of my stored procedure. How
> >can I go about doing it?
Received on Thu Apr 01 1999 - 17:54:04 CEST