Oracle VARRAY support

2009-04-01 Thread Udo Grabowski

Still dbi::Oracle does not support Oracle varray types. Any plans
to implement this ? Or does anybody know another perl connector
module that supports this type ? We still only can use the java
jdbc connectors which have support for that odd speciality.
--
Dr. Udo Grabowski   email: udo.grabow...@imk.fzk.de
Institut f. Meteorologie und Klimaforschung ASF,Forschungszentrum Karlsruhe
Postfach 3640, 76021 Karlsruhe, Germany Tel: (+49) 7247 82-6026
http://www.fzk.de/imk/asf/sat/grabowski/Fax: -7026


Re: Oracle VARRAY support

2009-04-01 Thread John Scoles

Actually it does support varray types since 1.20 (at least for select)

http://search.cpan.org/~pythian/DBD-Oracle-1.22/Oracle.pm#Object__Collection_Data_Types

You can select them all you want.  I have not yet added support for 
inserts and updates and that is handled by psql better than the hay that 
DBI  with DBD::Oracle would do it


In the trunk version of DBD::Oracle it can also load the Varray into 
Perl object rather than an ref array



Udo Grabowski wrote:

Still dbi::Oracle does not support Oracle varray types. Any plans
to implement this ? Or does anybody know another perl connector
module that supports this type ? We still only can use the java
jdbc connectors which have support for that odd speciality.