banaouas.medialog at wanadoo
Nov 15, 2007, 4:06 PM
Views: 1197
Permalink
|
|
ZSQL meyhod fr an Oracle Stored Procedure that Returns a ref_cur
|
|
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[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db
|
ZSQL meyhod fr an Oracle Stored Procedure that Returns a ref_cur