[Zope-DB] ZSQL meyhod fr an Oracle Stored Procedure that Returns a ref_cur

banaouas banaouas.medialog at wanadoo.fr
Thu Nov 15 19:06:04 EST 2007

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%'))


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.

More information about the Zope-DB mailing list