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

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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://727796]
help
Chatterbox?
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
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

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





    Results (159 votes), past polls