Re: Python sample code for PLSQL REF CURSORS

[Gerhard Häring]

A.M wrote:
> Hi,
> 
> I am having hard time to find a sample that shows me how to return an OUT 
> REF CURSOR from my oracle stored procedure to my python program. [...]

import cx_Oracle

con = cx_Oracle.connect("me/[EMAIL PROTECTED]")
cur = con.cursor()
outcur = con.cursor()
cur.execute("""
     BEGIN
         MyPkg.MyProc(:cur);
     END;""", cur=outcur)

for row in out_cur:
     print row

HTH,

-- Gerhard
-- 
http://mail.python.org/mailman/listinfo/python-list