DBMS_DESCRIBE.DESCRIBE_PROCEDURE missing levels in 19c
Hi,
The levels >0 are missing.
Documentation hasn't changed, they even show levels in their examples.
Below PL/SQL is executed, logged in as SYS, and output compared between 12c and 19c.
declare overload dbms_describe.number_table; position dbms_describe.number_table; lvl dbms_describe.number_table; argName dbms_describe.varchar2_table; dataType dbms_describe.number_table; defaultVal dbms_describe.number_table; inOut dbms_describe.number_table; len dbms_describe.number_table; prec dbms_describe.number_table; scale dbms_describe.number_table; radix dbms_describe.number_table; spare dbms_describe.number_table; begin dbms_describe.describe_procedure('DBMS_DESCRIBE.DESCRIBE_PROCEDURE',null,null,overload,position,lvl,argName,dataType,defaultVal,inOut,len,prec,scale,radix,spare); for c in 1..dataType.count loop dbms_output.put_line(position(c)||'/'||lvl(c)||' '||argName(c)||':'||dataType(c)); end loop; end;
Tagged:
1