Not sure how to do it otherwise. This is how its been coded -- what
is the alternative?
On May 9, 8:34 am, Michael Bayer <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
