Re: UTL_FILE example?

Hi Andrew,

Thanks for your help. I had an idea of the basic layout (similar to what you posted) but
I need help with the syntax for the

 --get your string

part of it. I can do the inserting into the table, etc. I know what position the strings will
be in (as if I were using SQLLOADER and I could say Position (271:345) because
that's there the 3 digit codes would be located in each line of the data file, if they exist).

I'm a relative newbie to this part of it. I've used SQLLOAD quite a few times but never with a loop so I'm at a loss. If I don't use SQLLOAD and I create a procedure
as you suggest, I'm not sure what syntax I need to actually get the string! As I've said,
it can be a string of UP TO 75 different three digit codes. I don't think INSTR would work...?

I do appreciate your help SO much!

Posting to newsgroup since email was returned as undeliverable!

AussieSyd/Maria S. wrote:

> I am looking for an example of a way to read a data file using UTL_FILE.
>
> I need to read a line, extract a six digit set of numbers, then insert
> the numbers
> into an Oracle table. Then I need to read the same line again and if
> there is another
> set of numbers, I need to insert them into the next row of the Oracle
> table. I need
> to loop through this row in the data file until I reach the end of the
> line. I'm having trouble finding a good example in my Oracle books. Can
> anyone help?
>
> Sincerely - and thank you in advance,
>
> Maria Singleton
Received on Fri Jul 23 1999 - 21:42:32 CEST