Re: Perl and Oracle

From: <krichine_at_juno.com>
Date: 9 Apr 2006 18:18:56 -0700
Message-ID: <1144631936.801931.131030@u72g2000cwu.googlegroups.com>

Have a look at:
http://search.cpan.org/~timb/DBI_AdvancedTalk/ specifically
http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/sld017.htm

gives an example of how to use array bulk fetches.

There are also examples available on how to use bulk binds. perldoc DBI
perldoc DBD::Oracle

It worked quite nicely for me.

In fact, it apparently worked quite nicely for Oracle, at least well enough to power their enterprise manager console website. Check out $ORACLE_HOME/perl/... after you install 10g release 2 and see what process and modules are running behind the scene with isqlplus and emctl

So far as supporting direct load, I don't think that's even the intention of DBI and DBD::Oracle
As with any tool, it should be used for the right job.

Kirill Received on Sun Apr 09 2006 - 20:18:56 CDT