Python sample code for PLSQL REF CURSORS

[A.M]

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.

The technique is explained here for Java and Visual Basic:

http://www.oracle-base.com/articles/...Recordsets.php

I am looking for similar code for Python

Any help would be appreciated,

Alan

[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/secret@tns")
cur = con.cursor()
outcur = con.cursor()
cur.execute("""
BEGIN
MyPkg.MyProc(:cur);
END;""", cur=outcur)

for row in out_cur:
print row

HTH,

-- Gerhard

[A.M]

Exactly what I was looking for.

Thanks alot
"Gerhard Häring" <[e-mail]> wrote in message
news:ma***************************************@pyt hon.org...

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/secret@tns")
cur = con.cursor()
outcur = con.cursor()
cur.execute("""
BEGIN
MyPkg.MyProc(:cur);
END;""", cur=outcur)

for row in out_cur:
print row

HTH,

-- Gerhard