Hello!
On Thu, 6 Sep 2007, John Scoles wrote:
Thanks Alexander that may come in handy as I am working on an extened
(generic) patch for Oracle embedded objects (Varry,nested Tavle etc) since
the start of the summer. I think your patch will help out alot for this as I
have only one or two little things (well actully not little at all, I can get
the data out of Oracle, but have yet to get it into Perl)
Not sure when this will be ready though most likly around the end of
September. I hope. Look for it in version 1.20
Ok. As I need support for standard Oracle array types SYS.DBMS_SQL.%
now, I'm going to implement at least ORA_VARCHAR2_TABLE, ORA_NUMBER_TABLE.
If you get generic implementation, we'll move to it then.
BTW, are you going to implement oracle native types, or you'll stay with
TO_CHAR conversion in array bind?
Bye. Alex.
----- Original Message ----- From: "Alexander V Alekseev" <[EMAIL PROTECTED]>
To: <dbi-dev@perl.org>
Sent: Wednesday, September 05, 2007 5:40 PM
Subject: [patch] DBD::Oracle - Support for array binds.
Hello!
A preliminary version of OCI array bind patch attached.
Apply to the latest trunk release.
Usage example also attached.
1) Only Varchar2 tables are supported. ( SYS.DBMS_SQL.VARCHAR2_TABLE )
2) utf8 is untested. Seems to currupt utf8 data on truncate.
3) Untested.
I plan to support bind of SYS.DBMS_SQL.NUMBER_TABLE also.
As I'm new to perl api, your comments are welcome.
Also, I cannot test the whole functionality much. So, bug
reports are welcome.
Bye. Alex.