[sf-perl] Perl DBI => named pipe => sqlldr => Oracle table

Loo, Peter # PHX Peter.Loo at source.wolterskluwer.com
Tue Jun 13 15:34:40 PDT 2006


Yes, I am aware of those modules listed at the link below.  In fact, I
have Oracle::Sqlldr loaded on our test environment.  I was unable to get
this module to work due to a problem with sqlldr not being able to
DESCRIBE the destination table.  I was working with Andrew McGregor and
was still working on this matter when I stumbled over the possible
culprit.  I am looking into it now.

On the thread below, please go ahead and close it out as I have found a

Thanks for all your help.

-----Original Message-----
From: sanfrancisco-pm-bounces+peter.loo=source.wolterskluwer.com at pm.org
[mailto:sanfrancisco-pm-bounces+peter.loo=source.wolterskluwer.com at pm.or
g] On Behalf Of Quinn Weaver
Sent: Tuesday, June 13, 2006 1:07 PM
To: San Francisco Perl Mongers User Group
Subject: Re: [sf-perl] Perl DBI => named pipe => sqlldr => Oracle table

On Tue, Jun 13, 2006 at 10:36:32AM -0700, Loo, Peter # PHX wrote:
> Hello All,
> I have the need to spawn two processes within Perl and was wondering 
> if someone can show me the way.
> One process open() a named pipe and the other runs "sqlldr 
> user/pass at database <BLOCKED::mailto:user/pass at database>
> control=controlfile.ctl etc...".


I have some ideas about what might be wrong, but before we repair your
wheel, why don't we see what others people have invented? ;)


That page shows three recently updated CPAN modules, each expressly
designed to speak to sqlldr.

I would go with one of those.  They're pretty much guaranteed to be
better-tested and more robust than your recently written code.
And you don't have to maintain them!  Man, I love CPAN. ;)

qw (Quinn Weaver); #President, San Francisco Perl Mongers =for
information, visit http://sf.pm.org/weblog =cut
SanFrancisco-pm mailing list
SanFrancisco-pm at pm.org

This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.

More information about the SanFrancisco-pm mailing list