Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (4)
As of 2018-01-17 00:14 GMT
Find Nodes?
    Voting Booth?
    How did you see in the new year?

    Results (194 votes). Check out past polls.