python调用oracle package
作者:
第三个账号 | 来源:发表于
2018-07-22 18:53 被阅读0次# -*- 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()
Oracle cx_Oracle python
VARCHAR2 cx_Oracle.STRING str
NVARCHAR2 cx_Oracle.STRING str
LONG cx_Oracle.STRING str
CHAR cx_Oracle.FIXED_CHAR str
NUMBER cx_Oracle.NUMBER int
FLOAT cx_Oracle.NUMBER float
DATE cx_Oracle.DATETIME datetime.datetime
TIMESTAMP cx_Oracle.TIMESTAMP datetime.datetime
CLOB cx_Oracle.CLOB cx_Oracle.LOB
BLOB cx_Oracle.BLOB cx_Oracle.LOB
本文标题:python调用oracle package
本文链接:https://www.haomeiwen.com/subject/dxfrmftx.html
网友评论