Re: SQL Loader via pipes

Jim,

        I have not tried this but I think it would work. I am also assuming that this is running under UNIX.

Try creating a FIFO or "named pipe" by issuing mknod <filename> p

This should create a pipe that looks like a file. You can write to the pipe like a normal file from your program. This will initially hang but if you start SQL*loader reading from the pipe, it should sping into life abd load the data as it is put into the pipe.

Hope this helps

Regards.....Simon

Jim Nissen <jim.nissen_at_internetMCI.com> wrote in article <32A4F133.6B3F_at_internetMCI.com>...
> I have a C program that writes a file that in turn gets loaded into a
> database via Oracle SQL*loader. Does anyone know of a way to pipe this
> data directly to SQL*loader via pipes rather than creating a file? TIA
>
> Jim Nissen
> jim.nissen_at_internetmci.com
>
  Received on Wed Dec 04 1996 - 00:00:00 CET