存储过程参数输入错误
CREATE OR REPLACE Procedure P_CZH_FLOW_ADD
(
Flow_Name in varchar2 default '',
--Flow_Type in number default 0,
Flow_Desc in varchar2 default '',
Flow_WishDate in number default 0,
Flow_MaxDate in number default 0,
Flow_Status in number default 0,
Flow_Creator in varchar2 default '',
Flow_Filltime in varchar2 default '',
Flow_ID out number
)
is
begin
Insert into t_Flow( flowname,Flowdescribe,Status,Wishdate,Maxdate,Creator,Filltime,flowid)
values (Flow_Name,Flow_Desc,Flow_Status,Flow_WishDate,Flow_MaxDate,Flow_Creator,TO_DATE(Flow_Filltime,'yyyy-mm-dd'),SEQ_T_FLOW.NEXTVAL);
select FLOWID INTO Flow_ID from (select FLOWID,rank() over(order by FLOWID DESC) rk from T_FLOW) where rk=1;
end;
以上存储过程编译可以通过,但是在程序传值过来以后总是会出现:
调用 'P_CZH_FLOW_ADD' 时参数个数或类型错误