Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re: streaming a .ctl file into sqlldr with perl

by jfroebe (Vicar)
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
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 meditating upon the Monastery: (7)
As of 2014-12-25 06:55 GMT
Find Nodes?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?

    Results (159 votes), past polls