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

Reply via email to