Re: Reading a file into PL/SQL Code

STARLITE wrote:
>
> I am still using oracle 7.1.6 and PL/SQL 2.1.6, I and reviewing in the
> PL/SQL Programming Book by Oracle Press a utility that will allow you
> to read a sequential file into PL/SQL code. Since I haven't got the
> correct version of PL/SQL Code to do this, can anyone offer a suggestion
> as to how I may read a system file sequentially with having to load it
> into a table first.
>
> Any help would be appreciative.
>
> Jeanette
> State University of West GA
> Carrollton GA 30118
> jeanette_at_westga.edu

Jeanette,

Given your restrictions, your only recourse prior to 7.3 is to communicate via DBMS_PIPES with a PRO*C program that will read the file for you and transfer info back to the PL/SQL block via the pipe.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.