Read Text file into Oracle Reports

From: <rishka_at_webmail.co.za>
Date: 17 Mar 2005 05:48:16 -0800
Message-ID: <1111067296.531721.202340_at_g14g2000cwa.googlegroups.com>



 Rishka Mar 17, 5:40 am show options

Newsgroups: comp.databases.oracle.tools
From: "Rishka" <ris..._at_webmail.co.za> - Find messages by this author Date: 17 Mar 2005 05:40:45 -0800
Local: Thurs, Mar 17 2005 5:40 am
Subject: Read Text file into Oracle Reports Reply | Reply to Author | Forward | Print | Individual Message | Show original | Remove | Report Abuse

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 Received on Thu Mar 17 2005 - 14:48:16 CET

Original text of this message