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;