Re: Read Text file into Oracle Reports

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..
>
> Thanks
> R
>

Find new managers. Probably better: find other job; any firm having this kind of managers...

Really... you have the text in a flat file; they want you to use a monster like Oracle Reports to get the data IN an Oracle instance, pre-process, report from it, format it in another process (other machine, perhaps - application server, anyone?) and create a file, that can be saved on the filesystsem?!?

-- 
Regards,
Frank van Bortel