Re: Python sample code for PLSQL REF CURSORS

[A.M]

Exactly what I was looking for.

Thanks alot


"Gerhard Häring" <[EMAIL PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
> 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