Java版百变平台调用储存过程范例
储存过程如下:
CREATE OR REPLACE PROCEDURE "ABC" (strInText in varchar, nInValue in number, strOutText out varchar, nOutValue out number)
as
begin
strOutText:= strInText||+'输出字符串';
nOutValue:= nInValue+11111;
end;
后台函数名称:DoProcedure
InputXML参数格式:
<Input>
<Sql>{Call 储存过程名称(?,?,..)}</Sql>
<Params>
<Param>
<InOut>参数输入输出类型(In/Out)</InOut>
<DataType>参数值类型(数值:8,字符:12,日期:91)</DataType>
<Value>参数值字符串</Value>
</Param>
...
</Params>
</Input>
返回格式:
<Output><Value_1>返回值字符串</Value_1><Value_2>返回值字符串2</Value_2>...</Output>
调用ABC存储过程范例:
strInput = "<Input><Sql>{ABC(?,?,?,?)}</Sql><Params>"
strInput = strInput+"<Param><InOut>In</InOut><DataType>12</DataType><Value>输入字符串</Value></Param>"
strInput = strInput+"<Param><InOut>In</InOut><DataType>8</DataType><Value>54321.09</Value></Param>"
strInput = strInput+"<Param><InOut>Out</InOut><DataType>12</DataType></Param>"
strInput = strInput+"<Param><InOut>Out</InOut><DataType>8</DataType></Param>"
strInput = strInput+"</Params></Input>"
strRet = DBEngine.WebFunction("DoProcedure", strInput, "")
strRet返回值如下:
<Output><Value_1>输入字符串输出字符串</Value_1><Value_2>65432.09</Value_2></Output>