Thanks Ron,
I am checking the net at the moment, to find out more
things aboput execute_array, some script to try it.
That is looking a little bit too complex for me :)
Also it is very hard to control what is happened to
the DML and such things.
The intergation is the most problematic area in all
projects, even simple like Perl + SQL*Loader :)
Thanks,
Zoran
- "Reidy, Ron" <Ron.Reidy_at_arraybiopharma.com> wrote:
> This question would better posed to Tim Bunce or to
> dbi-users_at_perl.org. I think there is work on array
> processing, or at least the plan to do so soon..
>
> However, if you want bulk operations, look at
> sending the data to a named pipe which is the input
> to SQL*Loader.
>
> -----------------
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
> Martic Zoran
> Sent: Thursday, March 10, 2005 1:49 AM
> To: oracle-l_at_freelists.org
> Subject: Perl again
>
>
> Hi all,
>
> I have a simple question about Perl that I found
> when
> I was testing the speed of Perl doing Oracle
> transactions. The main reason for testing it was
> that
> my company has the internal script language similar
> to
> Perl (do not ask me why is it invented, not me :)
> and
> I wanted it to compare the speed. Two targets:
> 1. Is our scirpting language slower then Perl?
> 2. Is Perl API nicer then ours and what we can do
> about it?
> The second was of course, Perl API is great and
> smart,
> but the first one !!!
>
> Back to question the question:
>
> Why Perl does not have bulk (array) DML supported?
>
> If I maybe missed it in the docs or somehow please
> let
> me know.
>
> Perl will be impressive high-performance Oracle
> client/server toolkit with this kind of
> fucntionality.
>
> Because we have all advanced OCI features
> implemented
> (array DML, ...) in our internal scripting language
> we
> could not believe it that Perl supported by so many
> people is without it.
>
> Any comment is welcome.
>
> Thanks,
> Zoran Martic
> Oracle Mine Worker
>
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/
> --
> http://www.freelists.org/webpage/oracle-l
>
> This electronic message transmission is a PRIVATE
> communication which contains
> information which may be confidential or privileged.
> The information is intended
> to be for the use of the individual or entity named
> above. If you are not the
> intended recipient, please be aware that any
> disclosure, copying, distribution
> or use of the contents of this information is
> prohibited. Please notify the
> sender of the delivery error by replying to this
> message, or notify us by
> telephone (877-633-2436, ext. 0), and then delete it
> from your system.
>
>
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 10 2005 - 11:51:04 CST
