1: PACKAGE BODY ec_execution_utils as
2: -- $Header: ECXUTILB.pls 115.24 2003/04/04 07:26:50 hgandiko ship $
3:
4: -- Internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
5: v_overload dbms_describe.number_table;
6: v_position dbms_describe.number_table;
7: v_level dbms_describe.number_table;
8: v_argumentname dbms_describe.varchar2_table;
1: PACKAGE BODY ec_execution_utils as
2: -- $Header: ECXUTILB.pls 115.24 2003/04/04 07:26:50 hgandiko ship $
3:
4: -- Internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
5: v_overload dbms_describe.number_table;
6: v_position dbms_describe.number_table;
7: v_level dbms_describe.number_table;
8: v_argumentname dbms_describe.varchar2_table;
9: v_datatype dbms_describe.number_table;
2: -- $Header: ECXUTILB.pls 115.24 2003/04/04 07:26:50 hgandiko ship $
3:
4: -- Internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
5: v_overload dbms_describe.number_table;
6: v_position dbms_describe.number_table;
7: v_level dbms_describe.number_table;
8: v_argumentname dbms_describe.varchar2_table;
9: v_datatype dbms_describe.number_table;
10: v_defaultvalue dbms_describe.number_table;
3:
4: -- Internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
5: v_overload dbms_describe.number_table;
6: v_position dbms_describe.number_table;
7: v_level dbms_describe.number_table;
8: v_argumentname dbms_describe.varchar2_table;
9: v_datatype dbms_describe.number_table;
10: v_defaultvalue dbms_describe.number_table;
11: v_inout dbms_describe.number_table;
4: -- Internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
5: v_overload dbms_describe.number_table;
6: v_position dbms_describe.number_table;
7: v_level dbms_describe.number_table;
8: v_argumentname dbms_describe.varchar2_table;
9: v_datatype dbms_describe.number_table;
10: v_defaultvalue dbms_describe.number_table;
11: v_inout dbms_describe.number_table;
12: v_length dbms_describe.number_table;
5: v_overload dbms_describe.number_table;
6: v_position dbms_describe.number_table;
7: v_level dbms_describe.number_table;
8: v_argumentname dbms_describe.varchar2_table;
9: v_datatype dbms_describe.number_table;
10: v_defaultvalue dbms_describe.number_table;
11: v_inout dbms_describe.number_table;
12: v_length dbms_describe.number_table;
13: v_precision dbms_describe.number_table;
6: v_position dbms_describe.number_table;
7: v_level dbms_describe.number_table;
8: v_argumentname dbms_describe.varchar2_table;
9: v_datatype dbms_describe.number_table;
10: v_defaultvalue dbms_describe.number_table;
11: v_inout dbms_describe.number_table;
12: v_length dbms_describe.number_table;
13: v_precision dbms_describe.number_table;
14: v_scale dbms_describe.number_table;
7: v_level dbms_describe.number_table;
8: v_argumentname dbms_describe.varchar2_table;
9: v_datatype dbms_describe.number_table;
10: v_defaultvalue dbms_describe.number_table;
11: v_inout dbms_describe.number_table;
12: v_length dbms_describe.number_table;
13: v_precision dbms_describe.number_table;
14: v_scale dbms_describe.number_table;
15: v_radix dbms_describe.number_table;
8: v_argumentname dbms_describe.varchar2_table;
9: v_datatype dbms_describe.number_table;
10: v_defaultvalue dbms_describe.number_table;
11: v_inout dbms_describe.number_table;
12: v_length dbms_describe.number_table;
13: v_precision dbms_describe.number_table;
14: v_scale dbms_describe.number_table;
15: v_radix dbms_describe.number_table;
16: v_spare dbms_describe.number_table;
9: v_datatype dbms_describe.number_table;
10: v_defaultvalue dbms_describe.number_table;
11: v_inout dbms_describe.number_table;
12: v_length dbms_describe.number_table;
13: v_precision dbms_describe.number_table;
14: v_scale dbms_describe.number_table;
15: v_radix dbms_describe.number_table;
16: v_spare dbms_describe.number_table;
17:
10: v_defaultvalue dbms_describe.number_table;
11: v_inout dbms_describe.number_table;
12: v_length dbms_describe.number_table;
13: v_precision dbms_describe.number_table;
14: v_scale dbms_describe.number_table;
15: v_radix dbms_describe.number_table;
16: v_spare dbms_describe.number_table;
17:
18: procedure printparams
11: v_inout dbms_describe.number_table;
12: v_length dbms_describe.number_table;
13: v_precision dbms_describe.number_table;
14: v_scale dbms_describe.number_table;
15: v_radix dbms_describe.number_table;
16: v_spare dbms_describe.number_table;
17:
18: procedure printparams
19: (
12: v_length dbms_describe.number_table;
13: v_precision dbms_describe.number_table;
14: v_scale dbms_describe.number_table;
15: v_radix dbms_describe.number_table;
16: v_spare dbms_describe.number_table;
17:
18: procedure printparams
19: (
20: i_procedure_name IN varchar2
90: then
91: -- Standard Call provided by Oracle RDBMS
92:
93: BEGIN
94: dbms_describe.describe_procedure
95: (
96: i_procedure_name,
97: null,
98: null,