Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Perl again

RE: Perl again

From: Reidy, Ron <>
Date: Thu, 10 Mar 2005 08:27:17 -0700
Message-ID: <>

This question would better posed to Tim Bunce or to = 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-----

[]On Behalf Of Martic Zoran Sent: Thursday, March 10, 2005 1:49 AM
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?=20
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.

Zoran Martic
Oracle Mine Worker



Do you Yahoo!?=20
Yahoo! Small Business - Try our new resources site!

This electronic message transmission is a PRIVATE communication which = contains
information which may be confidential or privileged. The information is = intended=20
to be for the use of the individual or entity named above. If you are = not the=20
intended recipient, please be aware that any disclosure, copying, = distribution=20
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.

-- Received on Thu Mar 10 2005 - 10:28:58 CST

Original text of this message