Oracle 的存储过程如下:
create or replace function my_add(add1 in integer, add2 in integer) return integer is
Result integer;
begin
result:=add1+add2;
return(Result);
end my_add;
asp如下调用:
<%
'cn为数据库连接对象
Set rs0=Server.CreateObject("ADODB.Recordset")
rs0.open "select my_add(" & 3 & "," & 4 & ") he from dual",cn,1,1
response.write rs0("he")
rs0.close
set rs0=nothing
%>