468,292 Members | 1,486 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,292 developers. It's quick & easy.

SQLAlchemy and Oracle Functions?

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

Mar 8 '07 #1
3 5173
On 8 Mar, 22:19, "Greg Copeland" <gtcopel...@gmail.comwrote:
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/sqlco...ause_functions
?

SQLAlchemy has its own google group

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

You could try asking there too.

Giles

Mar 8 '07 #2
On Mar 8, 3:35 pm, "Giles Brown" <giles_br...@hotmail.comwrote:
http://www.sqlalchemy.org/docs/sqlco...whereclause_fu...
SQLAlchemy has its own google group

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

You could try asking there too.

Giles
Very nice. That exactly answered by question. It works! Also, I
didn't know about the sqlalchemy group so I appreciate the heads up.

Thanks,

Greg
Mar 8 '07 #3
On 8 Mar, 15:35, "Giles Brown" <giles_br...@hotmail.comwrote:
On 8 Mar, 22:19, "Greg Copeland" <gtcopel...@gmail.comwrote:
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/sqlco...whereclause_fu...
?

SQLAlchemy has its own google group

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

You could try asking there too.

Giles

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

Mar 8 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

20 posts views Thread by John Salerno | last post: by
1 post views Thread by tomec | last post: by
1 post views Thread by Karlo Lozovina | last post: by
reply views Thread by Karlo Lozovina | last post: by
6 posts views Thread by Ilias Lazaridis | last post: by
reply views Thread by Greg Copeland | last post: by
reply views Thread by Nathan Harmston | last post: by
2 posts views Thread by Adam Kubica | last post: by
4 posts views Thread by --CELKO-- | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.