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 sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---