Rishka Mar 17, 5:40 am show options
Newsgroups: comp.databases.oracle.tools
From: "Rishka" <ris...@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
