PL/SQL (MOSC)

MOSC Banner

DBMS_DESCRIBE.DESCRIBE_PROCEDURE missing levels in 19c

edited Jan 12, 2022 12:26PM in PL/SQL (MOSC) 1 commentAnswered

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center