Re: PL/SQL and Unix flat files

In article <4pa1u0$ac6_at_pollux.cmc.doe.ca>, aj990_at_torfree.net (r brown) writes:
|>
|>
|> jstrange_at_imtn.dsccc.com (John Strange) wrote:
|> >:> Can PL/SQL read a unix flat file as input?
|> >
|> > Not that I am aware of since you did not include your
|> > release level of PL/SQL.
|> >
 

|> >Richard Bergdahl (rtb_at_interaccess.com) wrote:
|> >:> Can PL/SQL read a unix flat file as input?
|>
|>
|> I think you're wrong about that. I've seen postings here which mention a
|> package called dbms_text. Unfortunately, I haven't worked with it, so I can't
|> provide a lot of info.

The package is called UTL_FILE, and is available with PL/SQL 2.3, Oracle 7 Release 7.3. It allows you to read and write from server-side text files.

|>
|> It is supposed you give you the ability to read and write files.
|>
|> It wasn't part of the earlier pl/sql releases. You might not have it on your
|> system.
|>
|> Sorry I can't give you more help. I hope this is enough to point you in the
|> right direction, at least.
 

-- 
------------------------------------------------------------------------
Scott Urman            Oracle Corporation           surman_at_us.oracle.com
------------------------------------------------------------------------
Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2
Published by Oracle Press - http://www.osborne.com/oracle/index.htm
------------------------------------------------------------------------
"The opinions expressed here are my own, and are not necessarily that of
 Oracle Corporation"
------------------------------------------------------------------------