推荐订阅源

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>