Re: Can sql*loader read from pipes?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/05/31
Message-ID: <3390778b.2314437@newshost>#1/1

On Fri, 30 May 1997 13:52:05 GMT, Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de (Gerhard Moeller) wrote:

>Hi,
>
>I have a perl script that generates lots of data that I wish to copy
>into an Oracle table. I seem to cannot use INSERT as the data is too
>long (> 2000 characters). An idea would be to output the data on
>stdout (or any socket) and have SQL*Loader reading from stdin (or any
>socket). Can that be done?
>

It can easily use a named pipe on unix....

$ mknod data.dat p
$ cat stuff > data.dat &
$ sqlldr .... data=data.dat





>	Thanks for your help, Gerhard.

>--
> Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE
>
>OFFIS | | | | | | Tel.: 0441/9722-122
>Escherweg 2 | | | | | | Sekr.: 0441/9722-113 oder -101
>D-26121 Oldenburg |O|F|F|I|S| Fax: 0441/9722-102

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat May 31 1997 - 00:00:00 CDT