Hi,
I'm starting to query an oracle 10g XE database from zope using ZSQL.
I installed cx_Oracle-4.3.3-10g.win32-py2.4.exe and ZcxOracleDA-0.5.tar.gz.
It works fine for simple queries.
But how can I query a stored procedure returning a cursor ?
In python script, this sample works fine:
con = cx_Oracle.connect("my_user", "my_pass", "my_server")
cur = con.cursor()
sql = "begin MY_PACKAGE.MY_PROC(:p_Cursor, :p_NAME); end;"
cursor.execute(sql, (cur, 'DUPONT%'))
...
con.commit()
thanks
--
View this message in context: http://www.nabble.com/ZSQL-meyhod-fr-an-Oracle-Stored-Procedure-that-Returns-a-ref_cur-tf4818086.html#a13784650
Sent from the Zope - DB mailing list archive at Nabble.com.
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
I'm starting to query an oracle 10g XE database from zope using ZSQL.
I installed cx_Oracle-4.3.3-10g.win32-py2.4.exe and ZcxOracleDA-0.5.tar.gz.
It works fine for simple queries.
But how can I query a stored procedure returning a cursor ?
In python script, this sample works fine:
con = cx_Oracle.connect("my_user", "my_pass", "my_server")
cur = con.cursor()
sql = "begin MY_PACKAGE.MY_PROC(:p_Cursor, :p_NAME); end;"
cursor.execute(sql, (cur, 'DUPONT%'))
...
con.commit()
thanks
--
View this message in context: http://www.nabble.com/ZSQL-meyhod-fr-an-Oracle-Stored-Procedure-that-Returns-a-ref_cur-tf4818086.html#a13784650
Sent from the Zope - DB mailing list archive at Nabble.com.
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db