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