[Home] [Help]
263: *
264: */
265: function validateTemplate (template in varchar2 , name VARCHAR2, error_msg out nocopy varchar2) return boolean is
266:
267: prop_overload DBMS_DESCRIBE.NUMBER_TABLE;
268: prop_position DBMS_DESCRIBE.NUMBER_TABLE;
269: prop_c_level DBMS_DESCRIBE.NUMBER_TABLE;
270: prop_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
271: prop_dty DBMS_DESCRIBE.NUMBER_TABLE;
264: */
265: function validateTemplate (template in varchar2 , name VARCHAR2, error_msg out nocopy varchar2) return boolean is
266:
267: prop_overload DBMS_DESCRIBE.NUMBER_TABLE;
268: prop_position DBMS_DESCRIBE.NUMBER_TABLE;
269: prop_c_level DBMS_DESCRIBE.NUMBER_TABLE;
270: prop_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
271: prop_dty DBMS_DESCRIBE.NUMBER_TABLE;
272: prop_def_val DBMS_DESCRIBE.NUMBER_TABLE;
265: function validateTemplate (template in varchar2 , name VARCHAR2, error_msg out nocopy varchar2) return boolean is
266:
267: prop_overload DBMS_DESCRIBE.NUMBER_TABLE;
268: prop_position DBMS_DESCRIBE.NUMBER_TABLE;
269: prop_c_level DBMS_DESCRIBE.NUMBER_TABLE;
270: prop_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
271: prop_dty DBMS_DESCRIBE.NUMBER_TABLE;
272: prop_def_val DBMS_DESCRIBE.NUMBER_TABLE;
273: prop_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
266:
267: prop_overload DBMS_DESCRIBE.NUMBER_TABLE;
268: prop_position DBMS_DESCRIBE.NUMBER_TABLE;
269: prop_c_level DBMS_DESCRIBE.NUMBER_TABLE;
270: prop_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
271: prop_dty DBMS_DESCRIBE.NUMBER_TABLE;
272: prop_def_val DBMS_DESCRIBE.NUMBER_TABLE;
273: prop_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
274: prop_length DBMS_DESCRIBE.NUMBER_TABLE;
267: prop_overload DBMS_DESCRIBE.NUMBER_TABLE;
268: prop_position DBMS_DESCRIBE.NUMBER_TABLE;
269: prop_c_level DBMS_DESCRIBE.NUMBER_TABLE;
270: prop_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
271: prop_dty DBMS_DESCRIBE.NUMBER_TABLE;
272: prop_def_val DBMS_DESCRIBE.NUMBER_TABLE;
273: prop_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
274: prop_length DBMS_DESCRIBE.NUMBER_TABLE;
275: prop_precision DBMS_DESCRIBE.NUMBER_TABLE;
268: prop_position DBMS_DESCRIBE.NUMBER_TABLE;
269: prop_c_level DBMS_DESCRIBE.NUMBER_TABLE;
270: prop_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
271: prop_dty DBMS_DESCRIBE.NUMBER_TABLE;
272: prop_def_val DBMS_DESCRIBE.NUMBER_TABLE;
273: prop_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
274: prop_length DBMS_DESCRIBE.NUMBER_TABLE;
275: prop_precision DBMS_DESCRIBE.NUMBER_TABLE;
276: prop_scale DBMS_DESCRIBE.NUMBER_TABLE;
269: prop_c_level DBMS_DESCRIBE.NUMBER_TABLE;
270: prop_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
271: prop_dty DBMS_DESCRIBE.NUMBER_TABLE;
272: prop_def_val DBMS_DESCRIBE.NUMBER_TABLE;
273: prop_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
274: prop_length DBMS_DESCRIBE.NUMBER_TABLE;
275: prop_precision DBMS_DESCRIBE.NUMBER_TABLE;
276: prop_scale DBMS_DESCRIBE.NUMBER_TABLE;
277: prop_radix DBMS_DESCRIBE.NUMBER_TABLE;
270: prop_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
271: prop_dty DBMS_DESCRIBE.NUMBER_TABLE;
272: prop_def_val DBMS_DESCRIBE.NUMBER_TABLE;
273: prop_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
274: prop_length DBMS_DESCRIBE.NUMBER_TABLE;
275: prop_precision DBMS_DESCRIBE.NUMBER_TABLE;
276: prop_scale DBMS_DESCRIBE.NUMBER_TABLE;
277: prop_radix DBMS_DESCRIBE.NUMBER_TABLE;
278: prop_spare DBMS_DESCRIBE.NUMBER_TABLE;
271: prop_dty DBMS_DESCRIBE.NUMBER_TABLE;
272: prop_def_val DBMS_DESCRIBE.NUMBER_TABLE;
273: prop_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
274: prop_length DBMS_DESCRIBE.NUMBER_TABLE;
275: prop_precision DBMS_DESCRIBE.NUMBER_TABLE;
276: prop_scale DBMS_DESCRIBE.NUMBER_TABLE;
277: prop_radix DBMS_DESCRIBE.NUMBER_TABLE;
278: prop_spare DBMS_DESCRIBE.NUMBER_TABLE;
279:
272: prop_def_val DBMS_DESCRIBE.NUMBER_TABLE;
273: prop_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
274: prop_length DBMS_DESCRIBE.NUMBER_TABLE;
275: prop_precision DBMS_DESCRIBE.NUMBER_TABLE;
276: prop_scale DBMS_DESCRIBE.NUMBER_TABLE;
277: prop_radix DBMS_DESCRIBE.NUMBER_TABLE;
278: prop_spare DBMS_DESCRIBE.NUMBER_TABLE;
279:
280: exp_overload DBMS_DESCRIBE.NUMBER_TABLE;
273: prop_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
274: prop_length DBMS_DESCRIBE.NUMBER_TABLE;
275: prop_precision DBMS_DESCRIBE.NUMBER_TABLE;
276: prop_scale DBMS_DESCRIBE.NUMBER_TABLE;
277: prop_radix DBMS_DESCRIBE.NUMBER_TABLE;
278: prop_spare DBMS_DESCRIBE.NUMBER_TABLE;
279:
280: exp_overload DBMS_DESCRIBE.NUMBER_TABLE;
281: exp_position DBMS_DESCRIBE.NUMBER_TABLE;
274: prop_length DBMS_DESCRIBE.NUMBER_TABLE;
275: prop_precision DBMS_DESCRIBE.NUMBER_TABLE;
276: prop_scale DBMS_DESCRIBE.NUMBER_TABLE;
277: prop_radix DBMS_DESCRIBE.NUMBER_TABLE;
278: prop_spare DBMS_DESCRIBE.NUMBER_TABLE;
279:
280: exp_overload DBMS_DESCRIBE.NUMBER_TABLE;
281: exp_position DBMS_DESCRIBE.NUMBER_TABLE;
282: exp_c_level DBMS_DESCRIBE.NUMBER_TABLE;
276: prop_scale DBMS_DESCRIBE.NUMBER_TABLE;
277: prop_radix DBMS_DESCRIBE.NUMBER_TABLE;
278: prop_spare DBMS_DESCRIBE.NUMBER_TABLE;
279:
280: exp_overload DBMS_DESCRIBE.NUMBER_TABLE;
281: exp_position DBMS_DESCRIBE.NUMBER_TABLE;
282: exp_c_level DBMS_DESCRIBE.NUMBER_TABLE;
283: exp_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
284: exp_dty DBMS_DESCRIBE.NUMBER_TABLE;
277: prop_radix DBMS_DESCRIBE.NUMBER_TABLE;
278: prop_spare DBMS_DESCRIBE.NUMBER_TABLE;
279:
280: exp_overload DBMS_DESCRIBE.NUMBER_TABLE;
281: exp_position DBMS_DESCRIBE.NUMBER_TABLE;
282: exp_c_level DBMS_DESCRIBE.NUMBER_TABLE;
283: exp_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
284: exp_dty DBMS_DESCRIBE.NUMBER_TABLE;
285: exp_def_val DBMS_DESCRIBE.NUMBER_TABLE;
278: prop_spare DBMS_DESCRIBE.NUMBER_TABLE;
279:
280: exp_overload DBMS_DESCRIBE.NUMBER_TABLE;
281: exp_position DBMS_DESCRIBE.NUMBER_TABLE;
282: exp_c_level DBMS_DESCRIBE.NUMBER_TABLE;
283: exp_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
284: exp_dty DBMS_DESCRIBE.NUMBER_TABLE;
285: exp_def_val DBMS_DESCRIBE.NUMBER_TABLE;
286: exp_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
279:
280: exp_overload DBMS_DESCRIBE.NUMBER_TABLE;
281: exp_position DBMS_DESCRIBE.NUMBER_TABLE;
282: exp_c_level DBMS_DESCRIBE.NUMBER_TABLE;
283: exp_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
284: exp_dty DBMS_DESCRIBE.NUMBER_TABLE;
285: exp_def_val DBMS_DESCRIBE.NUMBER_TABLE;
286: exp_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
287: exp_length DBMS_DESCRIBE.NUMBER_TABLE;
280: exp_overload DBMS_DESCRIBE.NUMBER_TABLE;
281: exp_position DBMS_DESCRIBE.NUMBER_TABLE;
282: exp_c_level DBMS_DESCRIBE.NUMBER_TABLE;
283: exp_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
284: exp_dty DBMS_DESCRIBE.NUMBER_TABLE;
285: exp_def_val DBMS_DESCRIBE.NUMBER_TABLE;
286: exp_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
287: exp_length DBMS_DESCRIBE.NUMBER_TABLE;
288: exp_precision DBMS_DESCRIBE.NUMBER_TABLE;
281: exp_position DBMS_DESCRIBE.NUMBER_TABLE;
282: exp_c_level DBMS_DESCRIBE.NUMBER_TABLE;
283: exp_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
284: exp_dty DBMS_DESCRIBE.NUMBER_TABLE;
285: exp_def_val DBMS_DESCRIBE.NUMBER_TABLE;
286: exp_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
287: exp_length DBMS_DESCRIBE.NUMBER_TABLE;
288: exp_precision DBMS_DESCRIBE.NUMBER_TABLE;
289: exp_scale DBMS_DESCRIBE.NUMBER_TABLE;
282: exp_c_level DBMS_DESCRIBE.NUMBER_TABLE;
283: exp_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
284: exp_dty DBMS_DESCRIBE.NUMBER_TABLE;
285: exp_def_val DBMS_DESCRIBE.NUMBER_TABLE;
286: exp_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
287: exp_length DBMS_DESCRIBE.NUMBER_TABLE;
288: exp_precision DBMS_DESCRIBE.NUMBER_TABLE;
289: exp_scale DBMS_DESCRIBE.NUMBER_TABLE;
290: exp_radix DBMS_DESCRIBE.NUMBER_TABLE;
283: exp_arg_name DBMS_DESCRIBE.VARCHAR2_TABLE;
284: exp_dty DBMS_DESCRIBE.NUMBER_TABLE;
285: exp_def_val DBMS_DESCRIBE.NUMBER_TABLE;
286: exp_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
287: exp_length DBMS_DESCRIBE.NUMBER_TABLE;
288: exp_precision DBMS_DESCRIBE.NUMBER_TABLE;
289: exp_scale DBMS_DESCRIBE.NUMBER_TABLE;
290: exp_radix DBMS_DESCRIBE.NUMBER_TABLE;
291: exp_spare DBMS_DESCRIBE.NUMBER_TABLE;
284: exp_dty DBMS_DESCRIBE.NUMBER_TABLE;
285: exp_def_val DBMS_DESCRIBE.NUMBER_TABLE;
286: exp_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
287: exp_length DBMS_DESCRIBE.NUMBER_TABLE;
288: exp_precision DBMS_DESCRIBE.NUMBER_TABLE;
289: exp_scale DBMS_DESCRIBE.NUMBER_TABLE;
290: exp_radix DBMS_DESCRIBE.NUMBER_TABLE;
291: exp_spare DBMS_DESCRIBE.NUMBER_TABLE;
292: datatypes dbms_ldap.string_collection;
285: exp_def_val DBMS_DESCRIBE.NUMBER_TABLE;
286: exp_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
287: exp_length DBMS_DESCRIBE.NUMBER_TABLE;
288: exp_precision DBMS_DESCRIBE.NUMBER_TABLE;
289: exp_scale DBMS_DESCRIBE.NUMBER_TABLE;
290: exp_radix DBMS_DESCRIBE.NUMBER_TABLE;
291: exp_spare DBMS_DESCRIBE.NUMBER_TABLE;
292: datatypes dbms_ldap.string_collection;
293: idx INTEGER := 0;
286: exp_p_opt_mode DBMS_DESCRIBE.NUMBER_TABLE;
287: exp_length DBMS_DESCRIBE.NUMBER_TABLE;
288: exp_precision DBMS_DESCRIBE.NUMBER_TABLE;
289: exp_scale DBMS_DESCRIBE.NUMBER_TABLE;
290: exp_radix DBMS_DESCRIBE.NUMBER_TABLE;
291: exp_spare DBMS_DESCRIBE.NUMBER_TABLE;
292: datatypes dbms_ldap.string_collection;
293: idx INTEGER := 0;
294:
287: exp_length DBMS_DESCRIBE.NUMBER_TABLE;
288: exp_precision DBMS_DESCRIBE.NUMBER_TABLE;
289: exp_scale DBMS_DESCRIBE.NUMBER_TABLE;
290: exp_radix DBMS_DESCRIBE.NUMBER_TABLE;
291: exp_spare DBMS_DESCRIBE.NUMBER_TABLE;
292: datatypes dbms_ldap.string_collection;
293: idx INTEGER := 0;
294:
295: BEGIN
292: datatypes dbms_ldap.string_collection;
293: idx INTEGER := 0;
294:
295: BEGIN
296: DBMS_DESCRIBE.DESCRIBE_PROCEDURE(name, null, null,prop_overload,prop_position,prop_c_level,prop_arg_name,
297: prop_dty,prop_def_val,prop_p_opt_mode,prop_length,prop_precision,prop_scale,prop_radix,prop_spare);
298:
299: DBMS_DESCRIBE.DESCRIBE_PROCEDURE(template, null, null,
300: exp_overload,exp_position, exp_c_level,exp_arg_name,exp_dty,
295: BEGIN
296: DBMS_DESCRIBE.DESCRIBE_PROCEDURE(name, null, null,prop_overload,prop_position,prop_c_level,prop_arg_name,
297: prop_dty,prop_def_val,prop_p_opt_mode,prop_length,prop_precision,prop_scale,prop_radix,prop_spare);
298:
299: DBMS_DESCRIBE.DESCRIBE_PROCEDURE(template, null, null,
300: exp_overload,exp_position, exp_c_level,exp_arg_name,exp_dty,
301: exp_def_val,exp_p_opt_mode, exp_length,exp_precision, exp_scale,exp_radix,exp_spare);
302:
303: error_msg :=null;