Home » Open Source » Programming Interfaces » Python and Array of CLOBs using cx_Oracle (oracle 10g)
Python and Array of CLOBs using cx_Oracle [message #496541] Mon, 28 February 2011 16:37
Vackar
Messages: 81
Registered: October 2007
Member
Hi,

I am using cx_Oracle as a client onto a oracle stored procedure.

The procedure has 2 params:
1) A collection of varchar2
2) A collection of CLOBs

defined as


create type array_string as collection of varchar2(4000) index by pls_integer;

create type array_clob as collection of clob index by pls_integer;



I then have the proc:
create procedure proc_name(param1 in array_num, param2 array_clob)
...
...



The client calls this (and other) methods using cx_oracle.

It can successfully call procs with collections of numbers of collections of strings using arrayvar(cx_Oracle.STRING,vars)
etc, but when I attempt to apply the same logic to CLOBs it does not work.


Does anyone know the correct way of passing a collection of CLOBs to the procedure, or if this is even possible?

Thanks,
Vackar

Previous Topic: Perl DBI vs SQLPLUS vs TOAD
Next Topic: PHP-Oracle getting inserted rowID
Goto Forum:
  


Current Time: Thu Mar 28 08:54:11 CDT 2024