oracle array interface

Hi,

I saw on the web that the Oracle array interface has not been implemented
properly. I am new to DBI. Has the implementation been made more efficient?

Thanks,
Shree

Re: oracle array interface

On 5/29/06, Shreedhar Natarajan wrote:
> I saw on the web that the Oracle array interface has not been implemented
> properly. I am new to DBI. Has the implementation been made more efficient?

Would you care to provide a reference (URL) to justify the assertion?

--
Jonathan Leffler #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."

Re: oracle array interface

> > I saw on the web that the Oracle array interface has not been implemented
> > properly. I am new to DBI. Has the implementation been made more efficient?

> Would you care to provide a reference (URL) to justify the assertion?

http://www.dba-oracle.com/t_dbi_perl_connecting.htm

Concluding quote: "In other words, Perl with DBI and DBD::Oracle is
not an industry
strength tool for a production environment."

Good luck in finding some other tool, Shreedhar.

Stuart.

Re: oracle array interface

Stuart Cooper wrote:
>> > I saw on the web that the Oracle array interface has not been
>> implemented
>> > properly. I am new to DBI. Has the implementation been made more
>> efficient?
>
> http://www.dba-oracle.com/t_dbi_perl_connecting.htm
>
> Concluding quote: "In other words, Perl with DBI and DBD::Oracle is
> not an industry
> strength tool for a production environment."

This is a silly comment, somewhat surprising in the context
of an article that otherwise well demonstrates the capabiliities
of perl and DBI.

Thousands of organization have used DBI in "industry strength"
production applications for many, many years.

Don't waste your time worrying about abstract notions of efficient
or "proper implementation". Some features are not supported, as is
true with every tool, but those that are supported, are solid.

If you have a particular application that you need specific feature
support for, ask about that.

However, the shortcomings the author cites are basically true, for
example, DBI is not the tool for high-performance bulk loading.
(although it can be part of the solution, for example, I bulk
load TB's of data using parallel direct load and external tables,
and I drive it from DBI)

Mark