[cx-oracle-users] Calling a stored procedure with REFCUR out parameter
Brought to you by:
atuining
From: <Di...@ao...> - 2005-10-24 15:35:53
|
I got Oracle stored procedure, which looks like: PROCEDURE get_list(param1 IN VARCHAR2, param2 IN VARCHAR2, summary_cur OUT REFCUR). IS sql_stmt VARCHAR2(4000); BEGIN sql_stmt = 'SELECT a,b,c,d FROM Tab1, Tab2 WHERE Tab1.x = :param1 AND Tab2.y = :param2;' OPEN summary_cur FOR sql_stmt USING param1, param2; END get_list; Usually it returns more than 1 row. How can call this procedure, using cx_Oracle? To be more specific, how to specify the output parameter? Regards, Dmitriy Arapov |