eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.DBMS_UTILITY dependencies on UTL_IDENT

Line 3: $if utl_ident.is_oracle_server <> TRUE and

1: package dbms_utility is
2:
3: $if utl_ident.is_oracle_server <> TRUE and
4: utl_ident.is_timesten <> TRUE $then
5: $error 'dbms_utility is not supported in this environment' $end
6: $end
7:

Line 4: utl_ident.is_timesten <> TRUE $then

1: package dbms_utility is
2:
3: $if utl_ident.is_oracle_server <> TRUE and
4: utl_ident.is_timesten <> TRUE $then
5: $error 'dbms_utility is not supported in this environment' $end
6: $end
7:
8: ------------

Line 50: $if utl_ident.is_oracle_server $then

46: -- list of active instance number and instance name
47: -- the starting index of instance_table is 1
48: -- instance_table is dense
49:
50: $if utl_ident.is_oracle_server $then
51: TYPE anydata_array IS TABLE OF AnyData INDEX BY BINARY_INTEGER;
52: -- array of anydata
53: $else
54: /* AnyData type is not supported */

Line 133: $if utl_ident.is_oracle_server $then

129: * already valid or is an object that cannot be validated.
130: */
131: procedure validate(owner varchar2, objname varchar2, namespace number,
132: edition varchar2 :=
133: $if utl_ident.is_oracle_server $then
134: sys_context('USERENV', 'CURRENT_EDITION_NAME'));
135: $elsif utl_ident.is_timesten $then
136: -- no edition support for TimesTen, default it to null
137: null);

Line 135: $elsif utl_ident.is_timesten $then

131: procedure validate(owner varchar2, objname varchar2, namespace number,
132: edition varchar2 :=
133: $if utl_ident.is_oracle_server $then
134: sys_context('USERENV', 'CURRENT_EDITION_NAME'));
135: $elsif utl_ident.is_timesten $then
136: -- no edition support for TimesTen, default it to null
137: null);
138: $end
139:

Line 276: $if utl_ident.is_oracle_server $then

272: procedure invalidate(p_object_id number,
273: p_plsql_object_settings varchar2 default NULL,
274: p_option_flags pls_integer default 0);
275:
276: $if utl_ident.is_oracle_server $then
277: procedure analyze_schema(schema varchar2, method varchar2,
278: estimate_rows number default null,
279: estimate_percent number default null, method_opt varchar2 default null);
280: $else

Line 292: $if utl_ident.is_oracle_server $then

288: -- See the descriptions above in sql_ddl.analyze.object.
289: -- Exceptions:
290: -- ORA-20000: Insufficient privileges for some object in this schema.
291:
292: $if utl_ident.is_oracle_server $then
293: procedure analyze_database(method varchar2,
294: estimate_rows number default null,
295: estimate_percent number default null, method_opt varchar2 default null);
296: $else

Line 323: $if utl_ident.is_oracle_server $then

319: -- Output arguments:
320: -- format_call_stack
321: -- Returns the call stack. May be up to 2000 bytes.
322:
323: $if utl_ident.is_oracle_server $then
324: function is_cluster_database return boolean;
325: $else
326: /* is_cluster_database is not supported */
327: $end

Line 341: $if utl_ident.is_oracle_server $then

337: -- The returned elapsed time is the number of 100th's
338: -- of a second from some arbitrary epoch.
339: -- Related Function(s): "get_cpu_time" [See below].
340:
341: $if utl_ident.is_oracle_server $then
342: function get_parameter_value(parnam in varchar2,
343: intval in out binary_integer,
344: strval in out varchar2,
345: listno in binary_integer default 1)

Line 504: $if utl_ident.is_oracle_server $then

500: -- Convert a PL/SQL table of names into a comma-separated list of names
501: -- This is an overloaded version for supporting fully-qualified attribute
502: -- names.
503:
504: $if utl_ident.is_oracle_server $then
505: FUNCTION port_string RETURN VARCHAR2;
506: PRAGMA RESTRICT_REFERENCES(port_string, WNDS, RNDS, WNPS, RNPS);
507: $else
508: /* port_string is not supported */

Line 525: $if utl_ident.is_oracle_server $then

521: -- compatibility -> The compatibility setting of the database determined by
522: -- the "compatible" init.ora parameter. If the parameter
523: -- is not specified in the init.ora file, NULL is returned.
524:
525: $if utl_ident.is_oracle_server $then
526: function make_data_block_address(file number, block number) return number;
527: PRAGMA RESTRICT_REFERENCES(make_data_block_address, WNDS, RNDS, WNPS, RNPS);
528: $else
529: /* make_data_block_address is not supported */

Line 542: $if utl_ident.is_oracle_server $then

538: -- increments
539: -- Output arguments:
540: -- dba - the data block address
541:
542: $if utl_ident.is_oracle_server $then
543: function data_block_address_file(dba number) return number;
544: PRAGMA RESTRICT_REFERENCES(data_block_address_file, WNDS, RNDS, WNPS, RNPS);
545: $else
546: /* data_block_address_file is not supported */

Line 554: $if utl_ident.is_oracle_server $then

550: -- dba - a data block address
551: -- Output Arguments:
552: -- file - the file that contains the block
553:
554: $if utl_ident.is_oracle_server $then
555: function data_block_address_block(dba number) return number;
556: PRAGMA RESTRICT_REFERENCES(data_block_address_block, WNDS, RNDS, WNPS, RNPS);
557: $else
558: /* data_block_address_block is not supported */

Line 602: $if utl_ident.is_oracle_server $then

598: -- actual number. One could use an optional RAW parameter to
599: -- get all 16 bytes and to store the pre 10i hash value of 4
600: -- 4 bytes in the pre10ihash optional parameter.
601:
602: $if utl_ident.is_oracle_server $then
603: function sqlid_to_sqlhash(sql_id varchar2)
604: return number;
605: PRAGMA RESTRICT_REFERENCES(sqlid_to_sqlhash, WNDS, RNDS, WNPS, RNPS);
606: $else

Line 615: $if utl_ident.is_oracle_server $then

611: -- sql_id - SQL ID of a sql statement. Must be VARCHAR2(13).
612: -- Returns:
613: -- A hash value converted from the sql_id.
614:
615: $if utl_ident.is_oracle_server $then
616: procedure analyze_part_object
617: (schema in varchar2 default null,
618: object_name in varchar2 default null,
619: object_type in char default 'T',

Line 655: $if utl_ident.is_oracle_server $then

651: -- For V, it can be 'CASCADE' when object_type is T
652: -- sample_clause
653: -- Specifies the sample clause to use when command_type is 'E'
654:
655: $if utl_ident.is_oracle_server $then
656: procedure exec_ddl_statement(parse_string in varchar2);
657: -- Will execute the DDL statement in parse_string
658: -- parse_string
659: -- DDL statement to be executed

Line 664: $if utl_ident.is_oracle_server $then

660: $else
661: /* exec_ddl_statement is not supported */
662: $end
663:
664: $if utl_ident.is_oracle_server $then
665: function current_instance return number;
666: $else
667: /* current_instance is not supported */
668: $end

Line 672: $if utl_ident.is_oracle_server $then

668: $end
669: -- Return the current connected instance number
670: -- Return NULL when connected instance is down
671:
672: $if utl_ident.is_oracle_server $then
673: procedure active_instances(instance_table OUT instance_table,
674: instance_count OUT number);
675: $else
676: /* active_instances is not supported */

Line 692: $if utl_ident.is_oracle_server $then

688: -- give the type as 'TABLE'.
689: -- schema: The schema name of the object.
690: -- name: The name of the object.
691:
692: $if utl_ident.is_oracle_server $then
693: procedure create_alter_type_error_table ( schema_name IN VARCHAR2,
694: table_name IN VARCHAR2);
695: $else
696: /* create_alter_type_error_table is not supported */

Line 750: $if utl_ident.is_oracle_server $then

746: -- Return 1 if bit n in raw r is set. Bits are numbered high to low
747: -- with the lowest bit being bit number 1. This is a utility to assist
748: -- the view DBA_PENDING_TRANSACTION.
749:
750: $if utl_ident.is_oracle_server $then
751: procedure get_tz_transitions(regionid number,transitions OUT maxraw);
752: $else
753: /* get_tz_transitions is not supported */
754: $end

Line 773: $if utl_ident.is_oracle_server $then

769: -- These functions are temporarily provided for
770: -- *** Warning ***: backward compatibility and will be removed in
771: -- near future.
772: --
773: $if utl_ident.is_oracle_server $then
774: function old_current_schema return varchar2;
775: $else
776: /* old_current_schema is not supported */
777: $end

Line 779: $if utl_ident.is_oracle_server $then

775: $else
776: /* old_current_schema is not supported */
777: $end
778:
779: $if utl_ident.is_oracle_server $then
780: function old_current_user return varchar2;
781: $else
782: /* old_current_user is not supported */
783: $end

Line 822: $if utl_ident.is_oracle_server $then

818: -- dbms_output.put_line('CPU Time (in seconds)= '
819: -- || ((end_cpu_time - start_cpu_time)/100));
820: --
821:
822: $if utl_ident.is_oracle_server $then
823: function wait_on_pending_dml(tables in varchar2,
824: timeout in binary_integer,
825: scn in out number)
826: return boolean;

Line 857: $if utl_ident.is_oracle_server $then

853: -- Output: TRUE if all relevant transactions have committed or been
854: -- rolled back. FALSE if the timeout occurred prior to all relevant
855: -- transactions committing or being rolled back.
856:
857: $if utl_ident.is_oracle_server $then
858:
859: /*-----------------------------------------------------------------------------
860: Procedure: expand_sql_text
861: