Hello
I am trying to use Python and Cx_Oracle module for my
new project using linux and Oracle9i. I am getting the
following error while excuting the sample python code
(given below). Please help me out in rectifying the
error.
Regards
Nand
########### Code snippet....
## Python code snippet
#! /usr/local/bin/python
import cx_Oracle
import sys
connection = cx_Oracle.connect('test', 'test',
'test');
cursor = connection.cursor();
cursor.arraysize = 5;
print "some cx_Oracle information..",
cx_Oracle.version, cx_Oracle.apilevel,
cx_Oracle.buildtime
# ref cursor is returned as return value of a PL/SQL
function
refcur = cursor.callfunc('pkg_oratest.getRefCur',
cx_Oracle.CURSOR, [12])
print refcur.fetchall()
sys.exit
### PL/SQL finction code snippet
type cur_test_t is ref cursor;
function getRefCur(
pi_numArg1 in number
) return cur_test_t;
##### End PL/SQL Code
#### Error reported by Python/cx_Oracle
some cx_Oracle information.. HEAD 2.0 October 02,
2005 12:18:04
refcur = cursor.callfunc('pkg_oratest.getRefCur',
cx_Oracle.CURSOR, [12])
cx_Oracle.NotSupportedError:
Variable_TypeByPythonType(): unhandled data type
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
_______________________________________________
DB-SIG maillist - [email protected]
http://mail.python.org/mailman/listinfo/db-sig
