Xref: alice comp.databases.oracle.misc:15673
Path: alice!news-feed.fnsi.net!newsfeed.wli.net!news-feed.inet.tele.dk!bofh.vszbr.cz!newsfeed.ecrc.net!trader.ipf.net!not-for-mail
From: peter.schneider@okay.net (Peter Schneider)
Newsgroups: comp.databases.oracle.misc
Subject: Re: PL/SQL and input files
Date: Sun, 24 May 1998 15:07:18 GMT
Organization: UB Hoffmann
Lines: 30
Message-ID: <35683716.543009@news.okay.net>
References: <6k7o4f$ua7$1@camel29.mindspring.com>
X-Newsreader: Forte Free Agent 1.11/32.235

On Sat, 23 May 1998 19:59:17 -0400, "Kevin Bass"
<akil1@mindspring.com> wrote:

>Is it possible to read the data from an input file into a PL/SQL block?.  An
>example would like a file with the format of:
>
>123456789    Doe   John
>987654321    Doe   Jane
>
>Could this data be read into a PL/SQL block and used within the block?
>
>
>Kevin



Hi Kevin,

the UTL_FILE package on the server side and the TEXT_IO package in the
client side (ie Oracle Forms) are those that can do this job. But this
will require some programming to parse the file format, eg to parse
and seperate the fields in a logical record.

HTH
Peter


-- 
Peter Schneider
peter.schneider@okay.net