what does the DBAPI, pyodbc, have to say here ? When we use OUT parameters with cx_oracle, cx_oracle has explicit support for OUT params, and SQLAlchemy provides a special bind construct which works with it. To my knowledge pyodbc has no such feature.
SQL Server should support the construction of functions that have identical calling styles as that of Postgresql, I'd look into building wrapper functions around these outparam procedures that act the same as that of PG. Since you say you're looking for total parity between these two systems I'd assume PG is using stored procedures as well. Otherwise, these really aren't "equivalent" schemas and you'd pretty much just code whatever hardcoded/raw SQL thing you need for each case. On Jul 23, 2012, at 9:14 PM, Don Dwiggins wrote: > I'm writing code that I'd like to be "dialect-free" as much as possible; I'll > be using at least MS SQL and PostgreSQL databases with "equivalent" schemas. > In the MS DBs, there are stored procedures that have OUT parameters. The > only way that I've found in some web searching to get the values of these > parameters is to code direct SQL execs, followed by Selects of the output > values. Has anyone come up with a better way? > > Thanks, > -- > > Don Dwiggins > Advanced Publishing Technology > > > -- > 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 > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
