|
Listing 1: Creation of the record TYPE
TYPE one_argument_rt IS RECORD (
owner all_arguments.owner%TYPE,
package_name all_arguments.package_name%TYPE,
object_name all_arguments.object_name%TYPE,
overload PLS_INTEGER, -- from DBMS_DESCRIBE
position all_arguments.position%TYPE,
data_level all_arguments.data_level%TYPE,
argument_name all_arguments.argument_name%TYPE,
datatype PLS_INTEGER, -- from DBMS_DESCRIBE
default_value PLS_INTEGER, -- from DBMS_DESCRIBE
in_out PLS_INTEGER, -- from DBMS_DESCRIBE
character_set_name all_arguments.character_set_name%TYPE,
type_owner all_arguments.type_owner%TYPE,
type_name all_arguments.type_name%TYPE,
type_subname all_arguments.type_subname%TYPE,
type_link all_arguments.type_link%TYPE,
pls_type all_arguments.pls_type%TYPE,
char_length all_arguments.char_length%TYPE,
char_used all_arguments.char_used%TYPE
);
|