测试存储过程时,
declare
-- Local variables here
i integer;
type rc is ref cursor;
cur rc;
begin
-- Test statements here
print_name(20,:cur);
end;报参数类型错误
declare
-- Local variables here
i integer;
type rc is ref cursor;
cur rc;
begin
-- Test statements here
print_name(20,:cur);
end;报参数类型错误
i integer;
type rc is ref cursor;
cur rc;
v_sql varchar2(2000);
begin
v_sql := 'select * from table';
OPEN cur FOR V_SQL;
print_name(cur);
end;
不是,我这是调用存储过程进行测试,print_name(number,out sys_refcursor),在test window进行测试,不过好像声明
变量没用,得在下面小窗口直接改cur类型