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_SQL dependencies on UTL_IDENT

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

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

Line 4: utl_ident.is_timesten <> TRUE $then

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

Line 196: $if utl_ident.is_oracle_server $then

192: type Date_Table is table of date index by binary_integer;
193: type Blob_Table is table of Blob index by binary_integer;
194: type Clob_Table is table of Clob index by binary_integer;
195:
196: $if utl_ident.is_oracle_server $then
197: type Bfile_Table is table of Bfile index by binary_integer;
198: $else
199: /* BFILE datatypes are not supported */
200: $end

Line 202: $if utl_ident.is_oracle_server $then

198: $else
199: /* BFILE datatypes are not supported */
200: $end
201:
202: $if utl_ident.is_oracle_server $then
203: TYPE Urowid_Table IS TABLE OF urowid INDEX BY binary_integer;
204: $else
205: /* urowid is not supported in this environment */
206: $end

Line 211: $if utl_ident.is_oracle_server $then

207:
208: TYPE time_Table IS TABLE OF time_unconstrained INDEX BY binary_integer;
209: TYPE timestamp_Table IS TABLE OF timestamp_unconstrained INDEX BY binary_integer;
210:
211: $if utl_ident.is_oracle_server $then
212: TYPE time_with_time_zone_Table IS TABLE OF TIME_TZ_UNCONSTRAINED INDEX BY binary_integer;
213: TYPE timestamp_with_time_zone_Table IS TABLE OF
214: TIMESTAMP_TZ_UNCONSTRAINED INDEX BY binary_integer;
215: TYPE timestamp_with_ltz_Table IS TABLE OF

Line 439: $if utl_ident.is_oracle_server $then

435: procedure bind_variable(c in integer, name in varchar2,
436: value in clob character set any_cs);
437: pragma restrict_references(bind_variable,WNDS);
438:
439: $if utl_ident.is_oracle_server $then
440: procedure bind_variable(c in integer, name in varchar2, value in bfile);
441: pragma restrict_references(bind_variable,WNDS);
442: $else
443: /* BFILE overloads are not supported */

Line 479: $if utl_ident.is_oracle_server $then

475: procedure bind_array(c in integer, name in varchar2,
476: cl_tab in Clob_Table);
477: pragma restrict_references(bind_array,WNDS);
478:
479: $if utl_ident.is_oracle_server $then
480: procedure bind_array(c in integer, name in varchar2,
481: bf_tab in Bfile_Table);
482: pragma restrict_references(bind_array,WNDS);
483: $else

Line 509: $if utl_ident.is_oracle_server $then

505: cl_tab in Clob_Table,
506: index1 in integer, index2 in integer);
507: pragma restrict_references(bind_array,WNDS);
508:
509: $if utl_ident.is_oracle_server $then
510: procedure bind_array(c in integer, name in varchar2,
511: bf_tab in Bfile_Table,
512: index1 in integer, index2 in integer);
513: pragma restrict_references(bind_array,WNDS);

Line 564: $if utl_ident.is_oracle_server $then

560: procedure define_column(c in integer, position in integer,
561: column in clob character set any_cs);
562: pragma restrict_references(define_column,RNDS,WNDS);
563:
564: $if utl_ident.is_oracle_server $then
565: procedure define_column(c in integer, position in integer, column in bfile);
566: pragma restrict_references(define_column,RNDS,WNDS);
567: $else
568: /* BFILE overloads are not supported */

Line 604: $if utl_ident.is_oracle_server $then

600: cl_tab in Clob_Table,
601: cnt in integer, lower_bound in integer);
602: pragma restrict_references(define_array,RNDS,WNDS);
603:
604: $if utl_ident.is_oracle_server $then
605: procedure define_array(c in integer, position in integer,
606: bf_tab in Bfile_Table,
607: cnt in integer, lower_bound in integer);
608: pragma restrict_references(define_array,RNDS,WNDS);

Line 687: $if utl_ident.is_oracle_server $then

683: procedure column_value(c in integer, position in integer,
684: value out clob character set any_cs);
685: pragma restrict_references(column_value,RNDS,WNDS);
686:
687: $if utl_ident.is_oracle_server $then
688: procedure column_value(c in integer, position in integer, value out bfile);
689: pragma restrict_references(column_value,RNDS,WNDS);
690: $else
691: /* BFILE overloads are not supported */

Line 743: $if utl_ident.is_oracle_server $then

739: procedure column_value(c in integer, position in integer,
740: cl_tab in out nocopy Clob_table);
741: pragma restrict_references(column_value,RNDS,WNDS);
742:
743: $if utl_ident.is_oracle_server $then
744: procedure column_value(c in integer, position in integer,
745: bf_tab in out nocopy Bfile_table);
746: pragma restrict_references(column_value,RNDS,WNDS);
747: $else

Line 799: $if utl_ident.is_oracle_server $then

795: procedure variable_value(c in integer, name in varchar2,
796: value out clob character set any_cs);
797: pragma restrict_references(variable_value,RNDS,WNDS);
798:
799: $if utl_ident.is_oracle_server $then
800: procedure variable_value(c in integer, name in varchar2, value out bfile);
801: pragma restrict_references(variable_value,RNDS,WNDS);
802: $else
803: /* BFILE overloads are not supported */

Line 823: $if utl_ident.is_oracle_server $then

819: procedure variable_value(c in integer, name in varchar2,
820: value out nocopy Clob_table);
821: pragma restrict_references(variable_value,RNDS,WNDS);
822:
823: $if utl_ident.is_oracle_server $then
824: procedure variable_value(c in integer, name in varchar2,
825: value out nocopy Bfile_table);
826: pragma restrict_references(variable_value,RNDS,WNDS);
827: $else

Line 1002: $if utl_ident.is_oracle_server $then

998: -- columns of the query. This table is indexed from one to the number
999: -- of elements in the select list of the query.
1000: --
1001: -- Urowid support
1002: $if utl_ident.is_oracle_server $then
1003: procedure bind_variable(c in integer, name in varchar2,
1004: value in urowid);
1005:
1006: pragma restrict_references(bind_variable,WNDS);

Line 1133: $if utl_ident.is_oracle_server $then

1129: value out nocopy Timestamp_Table);
1130: pragma restrict_references(variable_value,RNDS,WNDS);
1131:
1132: -- time with timezone
1133: $if utl_ident.is_oracle_server $then
1134: procedure bind_variable(c in integer, name in varchar2,
1135: value in TIME_TZ_UNCONSTRAINED);
1136:
1137: pragma restrict_references(bind_variable,WNDS);

Line 1452: $if utl_ident.is_oracle_server $then

1448: pragma restrict_references(variable_value,RNDS,WNDS);
1449:
1450: -- Procedures and functions new in release 11
1451:
1452: $if utl_ident.is_oracle_server $then
1453: procedure bind_variable(c in integer, name in varchar2,
1454: value in "");
1455: pragma interface(c, bind_variable);
1456: pragma restrict_references(bind_variable,WNDS);

Line 1476: $if utl_ident.is_oracle_server $then

1472: value in "");
1473: pragma interface(c, bind_variable);
1474: pragma restrict_references(bind_variable,WNDS);
1475:
1476: $if utl_ident.is_oracle_server $then
1477: procedure bind_variable(c in integer, name in varchar2,
1478: value in "");
1479: pragma interface(c, bind_variable);
1480: pragma restrict_references(bind_variable,WNDS);

Line 1505: $if utl_ident.is_oracle_server $then

1501: value out "");
1502: pragma interface(c, variable_value);
1503: pragma restrict_references(variable_value,RNDS,WNDS);
1504:
1505: $if utl_ident.is_oracle_server $then
1506: procedure variable_value(c in integer, name in varchar2,
1507: value out "");
1508: pragma interface(c, variable_value);
1509: pragma restrict_references(variable_value,RNDS,WNDS);

Line 1534: $if utl_ident.is_oracle_server $then

1530: column in "");
1531: pragma interface(c, define_column);
1532: pragma restrict_references(define_column,RNDS,WNDS);
1533:
1534: $if utl_ident.is_oracle_server $then
1535: procedure define_column(c in integer, position in binary_integer,
1536: column in "");
1537: pragma interface(c, define_column);
1538: pragma restrict_references(define_column,RNDS,WNDS);

Line 1563: $if utl_ident.is_oracle_server $then

1559: value out "");
1560: pragma interface(c, column_value);
1561: pragma restrict_references(column_value,RNDS,WNDS);
1562:
1563: $if utl_ident.is_oracle_server $then
1564: procedure column_value(c in integer, position in binary_integer,
1565: value out "");
1566: pragma interface(c, column_value);
1567: pragma restrict_references(column_value,RNDS,WNDS);

Line 1619: $if utl_ident.is_oracle_server $then

1615:
1616: --------------------------------------------------------------------------
1617: -- Extended overloads for parse
1618:
1619: $if utl_ident.is_oracle_server $then
1620: procedure parse(c in integer,
1621: statement in varchar2,
1622: language_flag in integer,
1623: edition in varchar2);

Line 1733: $if utl_ident.is_oracle_server $then

1729:
1730: --------------------------------------------------------------------------
1731: -- Implicit result support
1732: --------------------------------------------------------------------------
1733: $if utl_ident.is_oracle_server $then
1734: function open_cursor(treat_as_client_for_results in boolean)
1735: return integer;
1736: pragma restrict_references(open_cursor,RNDS,WNDS);
1737:

Line 1746: $if utl_ident.is_oracle_server $then

1742: $else
1743: /* Implicit result not supported in this environment */
1744: $end
1745:
1746: $if utl_ident.is_oracle_server $then
1747: procedure return_result(rc in out sys_refcursor,
1748: to_client in boolean default true);
1749: procedure return_result(rc in out integer,
1750: to_client in boolean default true);

Line 1796: $if utl_ident.is_oracle_server $then

1792: -- PL/SQL, use DBMS_SQL to execute the recursive statement instead.
1793: --------------------------------------------------------------------------
1794:
1795: --------------------------------------------------------------------------
1796: $if utl_ident.is_oracle_server $then
1797: procedure get_next_result(c in integer, rc out sys_refcursor);
1798: procedure get_next_result(c in integer, rc out integer);
1799: pragma restrict_references(get_next_result,RNDS,WNDS);
1800: $else

Line 1855: $if utl_ident.is_oracle_server $then

1851: pragma restrict_references(variable_value,RNDS,WNDS);
1852:
1853: --------------------------------------------------------------------------
1854: -- Extended overloads for parse
1855: $if utl_ident.is_oracle_server $then
1856: procedure parse(c in integer,
1857: statement in varchar2,
1858: language_flag in integer,
1859: edition in varchar2 default NULL,