Re: tim bunce


On 12/20/2005 09:06:07 AM, c.w.huling@xxxxxxxxx wrote:
> Tim Bunce writes:
> > On Mon, Dec 19, 2005 at 01:28:32PM -0500, Mladen Gogala wrote:
> > >
> > > Why is it that I can't get a response to my question: when will
> > > DBD::Oracle fully support Oracle's array interface?
> >
> > I don't get paid to work on DBD::Oracle. It's a hobby, and one that
> > generally gives me far more headaches than it could possibly be worth.
> >
> > Patches welcome. Volunteers to help maintain it also welcome.
> > Take your pick.
> >
>
> I for appreciate your work on DBI/DBD! I have been working with
> DBD::Oracle for a few years now, and I am not 100% certain what is
> being requested? What part isn't supported?

Use of the array interface isn't supported. If I do bind_param_array and execute_array
DBD::Oracle will break it into single step executions. Recently, I had to load a file
of 20,000,000 records into a database. I wrote a perl script using bind_param_array and
execute_array and it worked much slower then anticipated. The reason was the array interface.
I had to re-write the file itself into a format that could be used by SQL Loader and
re-do the job. Perl DBI isn't very useful as a loading tool without the support for the
array interface.


>
> --
> C Wayne Huling <c.w.huling@xxxxxxxxx>
>
>

--
Mladen Gogala
http://www.mgogala.com

.

Relevant Pages

  • Re: tim bunce
    ... > Use of the array interface isn't supported. ... I wrote a perl script using ... > support for the ... it to batch load 20 million rows. ...
    (perl.dbi.users)
  • Re: Perl and Oracle
    ... it still doesn't support array interface. ... not meant for heavy duty data processing. ... renders Perl useless for any real data processing with Oracle. ...
    (comp.databases.oracle.server)
  • Re: Is Perl-DBI Slow?
    ... a toy as it doesn't use the native OCI array interface why don't you ... software doesn't support some basic things that almost any other software ... My sin is apparently one of omission. ...
    (perl.dbi.users)
  • Re: Creating C# components to be usable with multiple languages
    ... I do not know if Perl support COM ... the c++ client might call a function ... Analyze() in the c# class library. ... if I could implement this in a way where even a perl script ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Scripting language with a support for array interface
    ... >> Does it support array bind and, if it does, does it cheat like DBI ... I don't need array interface ... is there a scripting language with regular expressions ...
    (comp.databases.oracle.server)