Sounds like that's the way to go. I've got a couple of stored procedures for an app already, and I just wanted to change the platform it was on without having to rewrite the whole code.
I'll check it out. Previously, I was using cx_Oracle's cursor.execute to call queries to plsql stored procedures. Thanks guys. Wyatt Baldwin wrote: > On Apr 23, 6:50 pm, cd34 <[email protected]> wrote: > > SQLAlchemy (which can be installed with Pylons in the paster create -t > > pylons packagename) handles interaction with Oracle. > > > > http://www.sqlalchemy.org/docs/reference/dialects/oracle.html > > > You might need to drop down into cx_Oracle for stored procedures. You > can call Oracle *functions* easily using SQLAlchemy (import > sqlalchemy.sql.func, IIRC), but last time I looked, I didn't see a way > to call stored procedures from SQLAlchemy (other than writing straight > SQL). cx_Oracle has a cursor method called callproc (again, IIRC) that > I've used to call stored procedures. > > -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" 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/pylons-discuss?hl=en. -- You received this message because you are subscribed to the Google Groups "pylons-discuss" 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/pylons-discuss?hl=en.
