Re: Read Text file into Oracle Reports

On Thu, 17 Mar 2005 05:40:45 -0800, Rishka wrote:

> Hello
>
> I a newbie to Oracle Reports, our requirement is to write a report from
> a text file on the UNIX box, not from a database table.
> I have knowledge of PL/SQL, and the UTL_FILE ppackage to extract the
> file data and manipulate it..
> I would write a stored procedure for this, but our managers do not want
> us to write this data to a table and read it from there...
>
> Is it possible to extract data using PL/SQL from a text file into
> Oracle Reports?
>
> Please advise, or point me to the correct help..

Have you looked at the capability called 'External Table'. Works well if you can define the external file in terms of one or more columns. Search for "External Table" in the docco for a currently supported version of Oracle. Received on Thu Mar 17 2005 - 14:43:19 CET