Re: Flat file to Oracle

I don't see where is the problem using utl_file, but if you whant to use sql loader instead, you can use a shell script to call your external program, to check the ascii file for the number of fields, and build a sqlldr control file dynamically. After that calling the sqlldr ofcourse to load data.

On Wed, 19 Feb 2003 23:29:21 GMT, "Gavirel" <azvzq_at_yahoo.com> wrote:

>Thank you for answering my question. But the problem is that I have to call
>a system function to retrieve those files. that's why I need to write some
>script to generate the control file from the returned flat files, so is it
>still possible to use util_file. Thanks.
>
>
>"Donovan R." <mdonovan_at_hotmail.com> wrote in message
>news:9as55v8bqngc91thrp1qvfkjin9rlso03s_at_4ax.com...
>> use utl_file instead sqldr
>>
>>
>http://download-west.oracle.com/docs/cd/A87860_01/doc/appdev.817/a76936/utl_
>file.htm#998101
>>
>> On Tue, 18 Feb 2003 05:17:53 GMT, "Gavirel" <azvzq_at_yahoo.com> wrote:
>>
>> >Hi all,
>> >
>> >Recently, I need to import data from a lot of flat files to Oracle. And
 it
>> >will need to be done weekly. I am planning to use sqlldr. But the problem
 is
>> >these flat files have different number of fields. So, I am wondering does
>> >anyone know a way to generate control file and the sql file from the flat
>> >file?
>> >
>> >thank you so much
>> >
>> >G
>> >
>>
>
  Received on Sat Feb 22 2003 - 15:20:43 CET