asp调用oracle中自定义函数
这个函数的功能是 asp传入若干参数,函数把数据写入数据库中,,并返回0,1 0成功,1失败,并且输出写入的ID流水号
set cmd=server.CreateObject("adodb.command")
set cmd.ActiveConnection=objConnection
cmd.CommandText="函数名称"
cmd.commandType = 4
cmd.Prepared=true
cmd.Parameters.Append cmd.CreateParameter("v_oper_id",200,1,20,"WXZF")
cmd.Parameters.Append cmd.CreateParameter("v_busi_code",200,1,20,"2200")
cmd.Parameters.Append cmd.CreateParameter("v_check_type",200,1,20,"1")
cmd.Parameters.Append cmd.CreateParameter("v_bank_code",200,1,20,"WX")
cmd.Parameters.Append cmd.CreateParameter("v_bank_site_code",200,1,20,"")
cmd.Parameters.Append cmd.CreateParameter("v_flow_no",200,1,20,"WX100011212")
cmd.Parameters.Append cmd.CreateParameter("v_user_no",200,1,20,"1000012345")
cmd.Parameters.Append cmd.CreateParameter("v_charge_mode",200,1,20,"6")
cmd.Parameters.Append cmd.CreateParameter("v_verify_code",200,1,20,"")
cmd.Parameters.Append cmd.CreateParameter("v_money",3,1,3,100)
cmd.Parameters.Append cmd.CreateParameter("@v_charge_flowno",3,2,3,0)
v_charge_flowno这个是输出的系统ID号,,不知道为撒就是不执行,请高手看看