Hi Richard,
Thanks a lot.
It looks like a correct API.
Because I did the tests a few months ago, there is a
slight possibility that I missed it somehow.
But again this API is in DBI.
I was looking more DBD for Oracle I think and what DBD
implemented.
Probably stupid question but anyway.
Are you sure this is going to work in Oracle if DBD is
not supporting it?
Regards,
Zoran
- Richard Quintin <rquintin_at_vt.edu> wrote:
> Perl can do bulk DML operations. Take a look at
> bind_param_array and
> execute_array in DBI.
>
> on 03/10/2005 03:49 AM Martic Zoran scribbled:
>
> >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
> >
> >
>
> -=-=-
> Richard Quintin
> --
> "Evil when we are in its power is not felt as evil
> but as a necessity,
> or even a duty." -- Simone Weil
>
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 - 10:53:05 CST