SQLAlchemy and Oracle Functions?

G

Greg Copeland

I'm using SQLAlchemy and have a need to call an Oracle function; which
is not the same as a stored procedure. Can this be done directory or
indirectly with SQLAlchemy? If so, can someone please provide an
example? If not, how do I obtain the raw cx_Oracle cursor so I can
use callfunc directly on that?

Thanks,

Greg
 
G

Giles Brown

I'm using SQLAlchemy and have a need to call an Oracle function; which
is not the same as a stored procedure. Can this be done directory or
indirectly with SQLAlchemy? If so, can someone please provide an
example? If not, how do I obtain the raw cx_Oracle cursor so I can
use callfunc directly on that?

Thanks,

Greg

http://www.sqlalchemy.org/docs/sqlconstruction.myt#sql_whereclause_functions
?

SQLAlchemy has its own google group

http://groups.google.co.uk/group/sqlalchemy

You could try asking there too.

Giles
 
G

Greg Copeland



I think I spoke too soon! Are SQL functions which have out arguments
not allowed? I get:
sqlalchemy.exceptions.SQLError: (DatabaseError) ORA-06572: Function
blah has out arguments.

Seems google is having problems right now too. I tried to join but it
just times out so I am currently unable to post to the sqlalchemy
google group.

Anthing special I need to do to call an Oracle function via the func
method, which also has output parameters?


Greg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,480
Members
44,900
Latest member
Nell636132

Latest Threads

Top