Alternatively, convert to upper case with NLS_UPPER. If name is not a dotted name, and if name begins and ends with a double quote, remove both quotes. If name is NULL, canon_name becomes NULL. Returns the first canon_len bytes in canon_name. The length of the string (in bytes) to canonicalize Table 116-10 CANONICALIZE Procedure Parameters Parameter This procedure returns the active instance. Returns a string that uniquely identifies the version of Oracle and the operating systemД¬onverts a PL/SQL table of names into a comma-delimited list of names Invalidates a database object and (optionally) modifies its PL/SQL compiler parameter settingsДЇinds out if this database is running in cluster database modeД¬reates a data block address given a file number and a block number Gets the value of specified init.ora parameterДЇinds out the current time in 100th's of a second Shows the dependencies on the object passed in.Д¬omputes a hash value for the given string Returns the current CPU time in 100th's of a second Returns version information for the databaseД®xecutes the DDL statement in parse_stringДЇormats the backtrace from the point of the current error to the exception handler where the error has been caught Gets the file number part of a data block address Gets the block number part of a data block address Returns the current connected instance number Table 116-3 DBMS_UTILITY Package Subprograms SubprogramДЄnalyzes all the tables, clusters, and indexes in a database ДЄnalyzes all the tables, clusters, and indexes in a schema Д¬onverts a comma-delimited list of names into a PL/SQL table of namesД¬ompiles all procedures, functions, packages, and triggers in the specified schemaД¬reates an error table to be used in the EXCEPTION clause of the ALTER TYPE statement The following table lists the exceptions raised by DBMS_UTILITY. Obsolete with Oracle Database Release 10 g:

Lists of ' USER'.' NAME'.' COLUMN' should be stored here. TYPE uncl_array IS TABLE OF VARCHAR2(227) INDEX BY BINARY_INTEGER The order in which objects should be generated is returned here for users. TYPE number_array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER TYPE name_array IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER Lists of Long NAME should be stored here, it includes fully qualified attribute names. TYPE lname_array IS TABLE OF VARCHAR2(4000) index by BINARY_INTEGER The starting index of instance_table is 1 instance_table is dense. The list of active instance number and instance name. TYPE instance_table IS TABLE OF instance_record INDEX BY BINARY_INTEGER The order in which objects should be generated is returned here. TYPE index_table_type IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER Lists of database links should be stored here. TYPE dblink_array IS TABLE OF VARCHAR2(128) INDEX BY BINARY_INTEGER This constant is the only legal value for the p_option_flags parameter of the INVALIDATE subprogram

File exception error victoria 2