[sqlalchemy] Re: Result Set From An Oracle Function

2008-05-09 Thread Michael Bayer
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);

[sqlalchemy] Re: Result Set From An Oracle Function

2008-05-09 Thread Dan
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

[sqlalchemy] Re: Result Set From An Oracle Function

2008-05-09 Thread Michael Bayer
On May 9, 2008, at 10:20 AM, Dan wrote: Not sure how to do it otherwise. This is how its been coded -- what is the alternative? what happens if you just say, cursor.execute(select * from aaa_test(pWhen=:arg1, {'arg1':None}) using raw cx_oracle (and then cursor.fetchall()) ? doesn't