python 执行存储过程_python使用cx_oracle调用存储过程的问题

oracle存储过程如下：procedureprocxxxxx(p_BeginDateinvarchar2,p_EndDateinvarchar2,p_Disclosetypeinnumber:=null,p_ProjectCodeinvarchar2:=null,p_Disclosewayinvarchar2:=null,...

oracle存储过程如下：

procedure procxxxxx(

p_BeginDate in varchar2,

p_EndDate in varchar2,

p_Disclosetype in number := null,

p_ProjectCode in varchar2 := null,

p_Discloseway in varchar2 :=

null,

p_startrow in number := 0,

p_endrow in number

:= 999999,

p_status in varchar2 := null,

p_returncount in

out number,

p_ReasonCode out varchar2,

p_ReasonInfo out

varchar2,

p_cursor out refcursor

);

db = cx_Oracle.connect("customer/customer@uat")

cursor =

db.cursor()

l_cur = cursor.var(cx_Oracle.CURSOR)

ReasonCode

='qqq'

ReasonInfo ='www'

resutlt=

cx_Oracle.Cursor.callproc("procxxxxx",[begindate,enddate,'','','','','','','',ReasonCode,ReasonInfo,l_cur])

提示

TypeError: descriptor 'callproc' requires a 'OracleCursor' object but

received a

'str'

照着案例改的，但是没改成功，哪位大神指导下，谢谢~！

展开