387:
388: )
389: is
390:
391: l_overload dbms_describe.number_table;
392: l_position dbms_describe.number_table;
393: l_level dbms_describe.number_table;
394: l_argumentname dbms_describe.varchar2_table;
395: l_datatype dbms_describe.number_table;
388: )
389: is
390:
391: l_overload dbms_describe.number_table;
392: l_position dbms_describe.number_table;
393: l_level dbms_describe.number_table;
394: l_argumentname dbms_describe.varchar2_table;
395: l_datatype dbms_describe.number_table;
396: l_defaultvalue dbms_describe.number_table;
389: is
390:
391: l_overload dbms_describe.number_table;
392: l_position dbms_describe.number_table;
393: l_level dbms_describe.number_table;
394: l_argumentname dbms_describe.varchar2_table;
395: l_datatype dbms_describe.number_table;
396: l_defaultvalue dbms_describe.number_table;
397: l_inout dbms_describe.number_table;
390:
391: l_overload dbms_describe.number_table;
392: l_position dbms_describe.number_table;
393: l_level dbms_describe.number_table;
394: l_argumentname dbms_describe.varchar2_table;
395: l_datatype dbms_describe.number_table;
396: l_defaultvalue dbms_describe.number_table;
397: l_inout dbms_describe.number_table;
398: l_length dbms_describe.number_table;
391: l_overload dbms_describe.number_table;
392: l_position dbms_describe.number_table;
393: l_level dbms_describe.number_table;
394: l_argumentname dbms_describe.varchar2_table;
395: l_datatype dbms_describe.number_table;
396: l_defaultvalue dbms_describe.number_table;
397: l_inout dbms_describe.number_table;
398: l_length dbms_describe.number_table;
399: l_precision dbms_describe.number_table;
392: l_position dbms_describe.number_table;
393: l_level dbms_describe.number_table;
394: l_argumentname dbms_describe.varchar2_table;
395: l_datatype dbms_describe.number_table;
396: l_defaultvalue dbms_describe.number_table;
397: l_inout dbms_describe.number_table;
398: l_length dbms_describe.number_table;
399: l_precision dbms_describe.number_table;
400: l_scale dbms_describe.number_table;
393: l_level dbms_describe.number_table;
394: l_argumentname dbms_describe.varchar2_table;
395: l_datatype dbms_describe.number_table;
396: l_defaultvalue dbms_describe.number_table;
397: l_inout dbms_describe.number_table;
398: l_length dbms_describe.number_table;
399: l_precision dbms_describe.number_table;
400: l_scale dbms_describe.number_table;
401: l_radix dbms_describe.number_table;
394: l_argumentname dbms_describe.varchar2_table;
395: l_datatype dbms_describe.number_table;
396: l_defaultvalue dbms_describe.number_table;
397: l_inout dbms_describe.number_table;
398: l_length dbms_describe.number_table;
399: l_precision dbms_describe.number_table;
400: l_scale dbms_describe.number_table;
401: l_radix dbms_describe.number_table;
402: l_spare dbms_describe.number_table;
395: l_datatype dbms_describe.number_table;
396: l_defaultvalue dbms_describe.number_table;
397: l_inout dbms_describe.number_table;
398: l_length dbms_describe.number_table;
399: l_precision dbms_describe.number_table;
400: l_scale dbms_describe.number_table;
401: l_radix dbms_describe.number_table;
402: l_spare dbms_describe.number_table;
403:
396: l_defaultvalue dbms_describe.number_table;
397: l_inout dbms_describe.number_table;
398: l_length dbms_describe.number_table;
399: l_precision dbms_describe.number_table;
400: l_scale dbms_describe.number_table;
401: l_radix dbms_describe.number_table;
402: l_spare dbms_describe.number_table;
403:
404: --
397: l_inout dbms_describe.number_table;
398: l_length dbms_describe.number_table;
399: l_precision dbms_describe.number_table;
400: l_scale dbms_describe.number_table;
401: l_radix dbms_describe.number_table;
402: l_spare dbms_describe.number_table;
403:
404: --
405: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
398: l_length dbms_describe.number_table;
399: l_precision dbms_describe.number_table;
400: l_scale dbms_describe.number_table;
401: l_radix dbms_describe.number_table;
402: l_spare dbms_describe.number_table;
403:
404: --
405: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
406: --
409: IF l_debug_level > 0 THEN
410: oe_debug_pub.add( 'ENTERING CHECK_PROC API' ) ;
411: END IF;
412: BEGIN
413: dbms_describe.describe_procedure
414: (
415: p_procedure_name,
416: null,
417: null,