ASP调用oracle存储过程
健叶新吉橙 2005-10-08 01:33:13 ----------------------------
请帮我找一个ASP调用oracle存储过程(输入/出各一个参数)的代码。
以下是表与过程
------------------
'----------------------------------Table
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_bill_log_add
(inputremark varchar2,msg out float)
as
begin
insert into cd_bill_log(
bill_id,
deal_emp_id,
reach_date,
done_date,
bill_status,
deal_dept_id,remark)
values(
999,999,sysdate,''
,'O',999,inputremark);
msg:=1;
commit;
end;
--------------------------------