# -*- coding: utf-8 -*-
import cx_Oracle
conn = cx_Oracle.connect(
'user',
'pwd',
'tns')
cursor =
conn.cursor()
#声明变量
#调用存储过程
sql =
'''
declare result boolean;
begin
result := cmx_target_sql.test(o_error_message =>:o_error_message);
:result := sys.diutil.bool_to_int(result);
end;'''
result= cursor.var(cx_Oracle.NUMBER) msg=cursor.var(cx_Oracle.STRING) args = [msg,result] kwArgs = {} re = cursor.execute(sql, args, **kwArgs) conn.commit() print(result.getvalue()) print(msg.getvalue()) cursor.close() conn.close()
转载于:https://www.cnblogs.com/onelang/p/10121848.html
相关资源：Java程序如何调用Oracle中的存储过程
