Re: Reading flat files from pl/sql

from a stored PL/SQL procedure? yes, as long as it's on the database erver -- look into the UTL_FILE package

or are you referring to reading a file from the client machine? if so, what's your development tool?

note that in 9i you could also look into external tables (MetaLink note Note:150740.1)

• mcs

"Pedro Hernandez" <phph109_at_yahoo.es> wrote in message news:9d013a92.0311131124.8474bef_at_posting.google.com...
> This might seem strange, but I would like to know if it is possible to
> open a text file (for reading) from pl/sql.
>
> Ora8i on RHL7.3
>
>
> Thanks,
> ph
Received on Thu Nov 13 2003 - 20:40:45 CET