首页  »  网页设计教程  »  ASP调用oracle存储过程

ASP调用oracle存储过程

浏览数:共 569 次     评论:共 0 条     发布日期:2011-08-18     分类:asp

<!--#include file="incconn.asp"-->

<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title></title>

<%
"-----------------------------------
dim sp_common
set sp_common = server.createobject("adodb.command")
with sp_common
.activeconnection = conn
.commandtext = "cd_update_log"
.parameters.append .createparameter("@inputremark", advarchar, adparaminput,50,"联通.ye")
.parameters.append .createparameter("@msg", adinteger, adparamoutput)
.execute
end with

msg=sp_common("@msg")
"-----------------------------------
response.write "<hr>" &; msg
response.end

create table cd_bill_log
(
bill_id number,
deal_emp_id number,
reach_date date,
done_date date,
bill_status varchar2(10),
deal_dept_id number,
sign number,
remark varchar2(50)
)
;
"-----------------------proc
create or replace procedure
cd_update_log(inputremark varchar2,msg out float)
as
begin

update cd_bill_log a
set a.remark =inputremark --to_char(sysdate,"mi:ss")
where a.bill_id=45;
msg:=1;
commit;
end;

%>

</html>



上一篇:关于文摘插件提交表单的开发
下一篇:ASP访问INTERBASE数据库