Re: SQL*Loader and Stream Record Format - infodev_us_at_oracle.com solution

On Tue, 27 Dec 2005 12:29:59 -0500, <infodev_us_at_oracle.com> wrote:

Hi Oran,

I don't believe there is a feature like this. The typical workflow in such a case is to drive it through a script that retrieves the file with 'curl' or 'wget' and then calls SQL*Loader.

Thanks,
John

On Dec 27, 2005, at 4:45 AM, oran johnson wrote:

I have recently installed the express edition and loaded my first table. I would like to update this table using sql*loader. After going thur all the online documentation, I can not find any reference to accessing an internet data file. In other words, can I specify something like this: infile 'http://www.something.com/something.txt' in a sql*loader control file.

Regards.
Oran

On Thu, 29 Dec 2005 19:48:22 -0500, IANAL_VISTA <IANAL_Vista_at_hotmail.com> wrote:

> "oran johnson" <mobileoran_at_optonline.net> wrote in
> news:op.s2et13fwoireee_at_mobileoran:
>
> complaints WRT to previous responses & responders
>
> [...snip...]
>
> biting the hand that feeds you is a great way to starve.
>
> Enjoy the resounding silence to your problems.
>
> P.S.
> You can place within the INFILE anything you desire.
> Whether or not it is acceptable, is up to you to determine.
>
>
> HAND!

-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/