Oracle SQL Developer中调试，为什么SYS_REFCURSOR类型在“智能窗口”看不到返回值

[eHuaTian]

create or replace PROCEDURE CJSGETRECORD
(
TABLENAME IN VARCHAR2
, FIELDCOLS IN VARCHAR2
, JUDGEFIELD IN VARCHAR2
, JUDGEFIELDVALUE IN VARCHAR2
, recs IN OUT SYS_REFCURSOR
) is

p_str varchar2(4000);
BEGIN
IF (JUDGEFIELD is NULL) then
p_str :='select '||fieldCols||' from ' ||tableName|| '';
ELSE
p_str :='select '||FIELDCOLS||' from ' ||TABLENAME|| ' where ' || JUDGEFIELD|| '=' ||''''||JUDGEFIELDVALUE||'''';
END IF;

open recs for p_str;/*返回游标*/

END CJSGETRECORD;

在Oracle SQL Developer中调试上述过程，在“智能数据”窗口，为什么recs （SYS_REFCURSOR类型）看不到返回值？

[学海无涯-回头是岸]

用plsql试试呢

[eHuaTian]

如果用Oracle SQL Developer调试，怎么办呢？