Test the stored procedure,

 declare 
- Local variables here 
I the integer; 
Type the rc is ref cursor; 
Cur rc; 
The begin 
- the Test statements here 

Print_name (20, : cur); 
end; 

The parameter type errors

CodePudding user response:

You the wrong ah, give you a reference

Declare
I the integer;
Type the rc is ref cursor;
Cur rc;
V_sql varchar2 (2000);
The begin
V_sql:='select * from table';
The OPEN cur FOR V_SQL;
Print_name (cur);
end;

CodePudding user response:

reference 1st floor sxq129601 response:

you the wrong ah, give you a reference

Declare
I the integer;
Type the rc is ref cursor;
Cur rc;
V_sql varchar2 (2000);
The begin
V_sql:='select * from table';
The OPEN cur FOR V_SQL;
Print_name (cur);
end;

No, I this is call a stored procedure, print_name (number, out sys_refcursor), window to test in the test, but it seems the statement
Variables are useless, in small window directly below change type of cur

CodePudding user response:

Haven't seen the cursor type of debugging, if no problem, and debugging has problems, could be a debugging tool does not support