If your OS supports it you could use either a named pipe (see your system's mknod(1) man page); or if it has the support for named file descriptors use a pipe pair and tell it to read from /dev/fd/# (replacing the # with whatever fileno returns for the reader side; see perlipc for more on pipes). Then again it's possible that sqldr wants a seekable file and neither of these approaches will work and you'll be stuck with a temp file.
The cake is a lie.
The cake is a lie.
The cake is a lie.
| [reply] |
Looks like a continuation of your using stdin with sqlldr post. cmdrake pointed out that you should be able to use mkfifo/mknod to create a named pipe to load the data. Did this work for you?
| [reply] |
Hi, I didn't need to create a named pipe. The above code worked for me. I started sqlldr as a file handle and wrote to it like a file. The only addition that was made was a pipe in front of the sqlldr process call in the open function. So yes I guess it does open a pipe, just not the way I thought it would.
| [reply] |