DBA Data[Home] [Help]

PACKAGE: SYS.DBMS_LOBUTIL

Source


1 PACKAGE dbms_lobutil AS
2 
3 
4     -- inode query
5     FUNCTION getinode(lob_loc IN BLOB)
6         RETURN dbms_lobutil_inode_t DETERMINISTIC;
7         PRAGMA RESTRICT_REFERENCES(getinode, WNDS, RNDS, WNPS, RNPS, TRUST);
8 
9     FUNCTION getinode(lob_loc IN CLOB CHARACTER SET ANY_CS)
10         RETURN dbms_lobutil_inode_t DETERMINISTIC;
11         PRAGMA RESTRICT_REFERENCES(getinode, WNDS, RNDS, WNPS, RNPS, TRUST);
12 
13 
14     -- lobmap query
15     FUNCTION getlobmap(lob_loc IN BLOB, n IN NUMBER)
16         RETURN dbms_lobutil_lobmap_t DETERMINISTIC;
17         PRAGMA RESTRICT_REFERENCES(getlobmap, WNDS, RNDS, WNPS, RNPS, TRUST);
18 
19     FUNCTION getlobmap(lob_loc IN CLOB CHARACTER SET ANY_CS, n IN NUMBER)
20         RETURN dbms_lobutil_lobmap_t DETERMINISTIC;
21         PRAGMA RESTRICT_REFERENCES(getlobmap, WNDS, RNDS, WNPS, RNPS, TRUST);
22 
23 
24     -- extent expansion
25     FUNCTION getextents(crs IN sys_refcursor)
26         RETURN dbms_lobutil_lobextents_t DETERMINISTIC PIPELINED;
27         PRAGMA RESTRICT_REFERENCES(getextents, WNDS, RNDS, WNPS, RNPS, TRUST);
28 
29 
30     -- deduplication set query
31     FUNCTION getdedupset(lob_loc IN BLOB)
32         RETURN dbms_lobutil_dedupset_t DETERMINISTIC;
33         PRAGMA RESTRICT_REFERENCES(getdedupset, WNDS, RNDS, WNPS, RNPS, TRUST);
34 
35     FUNCTION getdedupset(lob_loc IN CLOB CHARACTER SET ANY_CS)
36         RETURN dbms_lobutil_dedupset_t DETERMINISTIC;
37         PRAGMA RESTRICT_REFERENCES(getdedupset, WNDS, RNDS, WNPS, RNPS, TRUST);
38 
39     -- copy the primary lob of a dedup set.
40     PROCEDURE copy_primary_dedup(lob_loc IN OUT NOCOPY BLOB,
41                               phash IN RAW, fhash IN RAW,
42                               scn IN NUMBER DEFAULT 0,
43                               par IN NUMBER);
44 
45     PROCEDURE copy_primary_dedup(lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
46                            phash IN RAW, fhash IN RAW,
47                            scn IN NUMBER DEFAULT 0,
48                            par IN NUMBER);
49 
50 END;