On May 9, 2008, at 4:26 AM, Dan wrote:
>
> Using cx_Oracle, the following does the trick (note this is a
> contrived example):
>
> def test(orcl_conn):
> curs = orcl_conn.cursor()
> cursorToBind = orcl_conn.cursor()
> curs.execute("""begin
> :cr1 := aaa_test(pWhen => :arg1);
> end;""", arg1 = None, cr1 = cursorToBind)
>
> marketData = {} # dictionary to hold the
> records
> i = 1
> for col in cursorToBind.fetchall():
> marketData[str(i)] = col
> i = i + 1
> return marketData
>
why is it necessary to send the cursor in as a bind parameter ? I've
used custom PL/SQL plenty and i've never heard of that technique.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
