Re: I/O - using PL/SQL, How can I read flat files with a stored procedure

In article <31BF12CF.73E9_at_MARITZ.COM>, Mary Ann Overkamp <OVERKAMA_at_MARITZ.COM> writes:
|> We are using PL/SQL version 2.1.3.2.0 on Oracle
|> server 7.1.3.2.0.
|> I can access flat files using Forms4.5 TEXT_IO
|> built in, but I need to move this code to a stored
|> program unit on the database and access it in a
|> batch mode nightly. I know UTL_FILE is supposed to
|> work but apparantly not in version 2.1. Any
|> suggestions as to how we access flat files? I am
|> new to oracle and oracle tools. Can anyone help?

The UTL_FILE package is available with Oracle 7.3 only. So you can either upgrade the server to 7.3, or use another solution, such as Pro*C or OCI, for your batch processing. You can do the file manipulation in C, and the SQL manipulation in either embedded SQL or stored procedures.

-- 
------------------------------------------------------------------------
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"
------------------------------------------------------------------------