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

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

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

Line 3: utl_ident.is_timesten <> TRUE $then

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

Line 127: $if utl_ident.is_oracle_server $then

123: encrypt_on CONSTANT PLS_INTEGER := opt_encrypt;
124: deduplicate_off CONSTANT PLS_INTEGER := 0;
125: deduplicate_on CONSTANT PLS_INTEGER := opt_deduplicate;
126:
127: $if utl_ident.is_oracle_server $then
128: -- DBFS Link State Values
129: dbfs_link_never CONSTANT PLS_INTEGER := 0;
130: dbfs_link_yes CONSTANT PLS_INTEGER := 1;
131: dbfs_link_no CONSTANT PLS_INTEGER := 2;

Line 324: $if utl_ident.is_oracle_server $then

320: PROCEDURE close(lob_loc IN OUT NOCOPY BLOB);
321:
322: PROCEDURE close(lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS);
323:
324: $if utl_ident.is_oracle_server $then
325: PROCEDURE close(file_loc IN OUT NOCOPY BFILE);
326: $else
327: /* BFILE overloads are not supported */
328: $end

Line 338: $if utl_ident.is_oracle_server $then

334: offset_2 IN INTEGER := 1)
335: RETURN INTEGER DETERMINISTIC;
336: PRAGMA RESTRICT_REFERENCES(compare, WNDS, RNDS, WNPS, RNPS);
337:
338: $if utl_ident.is_oracle_server $then
339: FUNCTION compare(file_1 IN BFILE,
340: file_2 IN BFILE,
341: amount IN INTEGER,
342: offset_1 IN INTEGER := 1,

Line 378: $if utl_ident.is_oracle_server $then

374: PROCEDURE erase(lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
375: amount IN OUT NOCOPY INTEGER,
376: offset IN INTEGER := 1);
377:
378: $if utl_ident.is_oracle_server $then
379: PROCEDURE fileclose(file_loc IN OUT NOCOPY BFILE);
380:
381: PROCEDURE filecloseall;
382:

Line 421: $if utl_ident.is_oracle_server $then

417: FUNCTION getlength(lob_loc IN CLOB CHARACTER SET ANY_CS)
418: RETURN INTEGER DETERMINISTIC;
419: PRAGMA RESTRICT_REFERENCES(getlength, WNDS, RNDS, WNPS, RNPS);
420:
421: $if utl_ident.is_oracle_server $then
422: FUNCTION getlength(file_loc IN BFILE)
423: RETURN INTEGER DETERMINISTIC;
424: PRAGMA RESTRICT_REFERENCES(getlength, WNDS, RNDS, WNPS, RNPS);
425: $else

Line 453: $if utl_ident.is_oracle_server $then

449: function isopen(lob_loc in clob character set any_cs)
450: RETURN INTEGER;
451: PRAGMA RESTRICT_REFERENCES(isopen, WNDS, RNDS, WNPS, RNPS);
452:
453: $if utl_ident.is_oracle_server $then
454: function isopen(file_loc in bfile)
455: RETURN INTEGER;
456: PRAGMA RESTRICT_REFERENCES(isopen, WNDS, RNDS, WNPS, RNPS);
457:

Line 489: $if utl_ident.is_oracle_server $then

485: $else
486: /* BFILE overloads are not supported */
487: $end
488:
489: $if utl_ident.is_oracle_server $then
490: PROCEDURE convertToClob(dest_lob IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
491: src_blob IN BLOB,
492: amount IN INTEGER,
493: dest_offset IN OUT INTEGER,

Line 517: $if utl_ident.is_oracle_server $then

513:
514: PROCEDURE open(lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
515: open_mode IN BINARY_INTEGER);
516:
517: $if utl_ident.is_oracle_server $then
518: PROCEDURE open(file_loc IN OUT NOCOPY BFILE,
519: open_mode IN BINARY_INTEGER := file_readonly);
520: $else
521: /* BFILE overloads are not supported */

Line 538: $if utl_ident.is_oracle_server $then

534: nth IN INTEGER := 1)
535: RETURN INTEGER DETERMINISTIC;
536: PRAGMA RESTRICT_REFERENCES(instr, WNDS, RNDS, WNPS, RNPS);
537:
538: $if utl_ident.is_oracle_server $then
539: FUNCTION instr(file_loc IN BFILE,
540: pattern IN RAW,
541: offset IN INTEGER := 1,
542: nth IN INTEGER := 1)

Line 560: $if utl_ident.is_oracle_server $then

556: amount IN OUT NOCOPY INTEGER,
557: offset IN INTEGER,
558: buffer OUT VARCHAR2 CHARACTER SET lob_loc%CHARSET);
559:
560: $if utl_ident.is_oracle_server $then
561: PROCEDURE read(file_loc IN BFILE,
562: amount IN OUT NOCOPY INTEGER,
563: offset IN INTEGER,
564: buffer OUT RAW);

Line 581: $if utl_ident.is_oracle_server $then

577: offset IN INTEGER := 1)
578: RETURN VARCHAR2 CHARACTER SET lob_loc%CHARSET DETERMINISTIC;
579: PRAGMA RESTRICT_REFERENCES(substr, WNDS, RNDS, WNPS, RNPS);
580:
581: $if utl_ident.is_oracle_server $then
582: FUNCTION substr(file_loc IN BFILE,
583: amount IN INTEGER := 32767,
584: offset IN INTEGER := 1)
585: RETURN RAW DETERMINISTIC;

Line 615: $if utl_ident.is_oracle_server $then

611: PROCEDURE writeappend(lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
612: amount IN INTEGER,
613: buffer IN VARCHAR2 CHARACTER SET lob_loc%CHARSET);
614:
615: $if utl_ident.is_oracle_server $then
616: -- fragment update API
617:
618: PROCEDURE fragment_insert(
619: lob_loc IN OUT NOCOPY BLOB,

Line 677: $if utl_ident.is_oracle_server $then

673: $else
674: /* fragment operations are not supported */
675: $end
676:
677: $if utl_ident.is_oracle_server $then
678: FUNCTION getoptions(
679: lob_loc IN BLOB,
680: option_types IN PLS_INTEGER
681: ) RETURN PLS_INTEGER;

Line 705: $if utl_ident.is_oracle_server $then

701: $else
702: /* get and set options feature not supported in this environment */
703: $end
704:
705: $if utl_ident.is_oracle_server $then
706: PROCEDURE get_deduplicate_regions(
707: lob_loc IN BLOB,
708: region_table IN OUT NOCOPY BLOB_DEDUPLICATE_REGION_TAB
709: );