Dear Tim Bunce,

Can I bind a perl's array to PL/SQL table?
For reference I have pasted your reply from the forum.

Does this still hold true for current release of dbi?


Your reply or suggestion in this regard will be greatly appreciated.

Thanks in advance

Regards
Vijay


*** From dbi-users -- To unsubscribe, see the end of this message. ***

> From: "Pavel Yu. Karasev" <[EMAIL PROTECTED]>
> 
> I'm trying to call from Perl the following stored PL/SQL procedure:
> (perl v 5.?, DBD-Oracle-0.45, DBI-0.83)
> ---cut---
> TYPE StrArray IS TABLE OF VARCHAR2(220) INDEX BY BINARY_INTEGER;
> PROCEDURE ApplyDoc(doc_numbers in StrArray) IS ...
> ---cut---


You can't bind to Oracle arrays/tables, only single values.


Tim.

Visit our website at http://www.ubswarburg.com

This message contains confidential information and is intended only
for the individual named.  If you are not the named addressee you
should not disseminate, distribute or copy this e-mail.  Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses.  The sender therefore
does not accept liability for any errors or omissions in the contents
of this message which arise as a result of e-mail transmission.  If
verification is required please request a hard-copy version.  This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities or
related financial instruments.

Reply via email to