美文网首页
python调用oracle package

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