Can sql*loader read from pipes?

From: Gerhard Moeller <Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de>
Date: 1997/05/30
Message-ID: <5mmm26$gm6@news.Informatik.Uni-Oldenburg.DE>#1/1

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?

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

Received on Fri May 30 1997 - 00:00:00 CDT