This content has been marked as final. Show 2 replies
It's easy, just define two cursors, one for the proc to execute and one for the ref cursor. Here an example (not tested but more or less that's the way).
v_sid = 1
cur1 = conn.cursor() # assuming conn is a valid oracle connection
cur2 = conn.cursor()
cur1.callproc("HC_CONTSEARC", (0,'Colorado Springs','CO',87,500000,100000,1,32,'d',0,v_sid,cur2))