Rishka Mar 17, 5:40 am show options

Newsgroups: comp.databases.oracle.tools
From: "Rishka" <ris... (AT) webmail (DOT) 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

http://groups.google.ca/groups?hl=en...66%40gmail.com

.... and cross-posting or multi-posting into the comp.databases.oracle
heirarchy doesn't speed things up either.