Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: streaming a .ctl file into sqlldr with perl

by jfroebe (Parson)
on Dec 03, 2008 at 20:27 UTC ( #727796=note: print w/ replies, xml ) Need Help??

in reply to streaming a .ctl file into sqlldr with perl

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?

Jason L. Froebe

Blog, Tech Blog

Comment on Re: streaming a .ctl file into sqlldr with perl
Replies are listed 'Best First'.
Re^2: streaming a .ctl file into sqlldr with perl
by chuckd (Scribe) on Dec 08, 2008 at 20:20 UTC
    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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://727796]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (5)
As of 2015-12-01 01:36 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (791 votes), past polls