create or replace procedure pro(
p_1 nvarchar2,
p_2 nvarchar2,
p_3 nvarchar2,
p_4 nvarchar2,
p_5 nvarchar2,
p_6 nvarchar2,
P_7 number,
P_8 number,
p_9 out number,
p_10 OUT types.cursorType)
IS
....参数: [2010-04-25, 2010-06-05, 81, DIFFFFFFF, null, 0, 0, 10]请问一下测试这个存储过程sql语句怎么写啊?call pro(这里?。。
p_1 nvarchar2,
p_2 nvarchar2,
p_3 nvarchar2,
p_4 nvarchar2,
p_5 nvarchar2,
p_6 nvarchar2,
P_7 number,
P_8 number,
p_9 out number,
p_10 OUT types.cursorType)
IS
....参数: [2010-04-25, 2010-06-05, 81, DIFFFFFFF, null, 0, 0, 10]请问一下测试这个存储过程sql语句怎么写啊?call pro(这里?。。
end ;
/
pro('2010-04-25',
--.....把参数填完
);
end;
/
p_10 OUT types.cursorType这两个参数也要写吗,怎么写啊?
declare
v_cursor sys_refcursor;
begin
pro('2010-04-25',
.....,
v_cursor
);
end;
/