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/8i/UsingRefCursorsToReturnRecordsets.php



I am looking for similar code for Python



Any help would be appreciated,

Alan

 

[=?ISO-8859-1?Q?Gerhard_H=E4ring?=]

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.MyProccur);
END;""", cur=outcur)

for row in out_cur:
print row

HTH,

-- Gerhard

 

[A.M]

Exactly what I was looking for.

Thanks alot

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.MyProccur);
END;""", cur=outcur)

for row in out_cur:
print row

HTH,

-- Gerhard