Hey all,
I have to call some pre-existing Oracle stored procedures that have
cursor out parameters. I've had no luck doing this short of using
"raw" cursors. Is there a better way to do this?
Here is a simple stored procedure modelled after what I have to call:
create or replace package TEST_PKG as
type refcur is ref cursor;
procedure simple_read(p_param out refcur);
end TEST_PKG;
/
create or replace package body TEST_PKG as
procedure simple_read(p_param out refcur) as
begin
open p_param for
select name from some_table;
end simple_read;
end TEST_PKG;
/
Here is the only code I was able to find that worked:
import sqlalchemy
engine = sqlalchemy.create_engine('oracle://<user>:<pwd>@<db>')
oracle_conn = engine.raw_connection()
in_cursor = oracle_conn.connection.cursor()
out_cursor = oracle_conn.connection.cursor()
in_cursor.execute('begin TEST_PKG.simple_read(:x); end;', x =
out_cursor)
results = out_cursor.fetchall()
print repr(results)
Any suggestions in how I can better do this with sqlalchemy?
Thanks!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
