PACKAGE: SYS.DBMS_STREAMS

Source

1 PACKAGE dbms_streams AUTHID CURRENT_USER AS
2 
3   -------------
4   -- CONSTANTS
5 
6   -- sets the binary tag for all LCRs subsequently generated by the
7   -- current session. Each LCR created by DML or DDL statement
8   -- in the current session will have this tag.
9   -- this procedure is not transactional and not affected by rollback
10   -- Note: the invoker of set_tag should have execute privilege on
11   --       dbms_streams_adm or execute_catalog_role
12   PROCEDURE set_tag(tag IN RAW DEFAULT NULL);
13 
14   -- get the binary tag for all LCRs generated by the current session.
15   -- Note: the invoker of get_tag should have execute privilege on
16   --       dbms_streams_adm or execute_catalog_role
17   FUNCTION get_tag RETURN RAW;
18 
19   -- get the Streams name. Returns NULL if not in Streams environment.
20   FUNCTION get_streams_name RETURN VARCHAR2;
21 
22   -- get the Streams type: APPLY, CAPTURE, PROPAGATION or ERROR_EXECUTION.
23   -- Returns NULL if not in Streams environment.
24   FUNCTION get_streams_type RETURN VARCHAR2;
25 
26   -- transformation function to convert from Sys.Anydata to SYS.LCR$_ROW_RECORD
27   FUNCTION convert_anydata_to_lcr_row(source SYS.ANYDATA) return SYS.LCR$_ROW_RECORD;
28 
29   -- transformation function to convert from Sys.Anydata to SYS.LCR$_DDL_RECORD
30   FUNCTION convert_anydata_to_lcr_ddl(source SYS.ANYDATA)
31     return SYS.LCR$_DDL_RECORD;
32 
33   -- generic function to get values of some of the properties
34   FUNCTION get_information(name IN VARCHAR2) RETURN SYS.ANYDATA;
35 
36   -- internal compatible representation for 9.2
37   FUNCTION compatible_9_2 RETURN INTEGER;
38 
39   -- internal compatible representation for 10.1
40   FUNCTION compatible_10_1 RETURN INTEGER;
41 
42   -- internal compatible representation for 10.2
43   FUNCTION compatible_10_2 RETURN INTEGER;
44 
45   -- internal compatible representation for 11.1
46   FUNCTION compatible_11_1 RETURN INTEGER;
47 
48   -- internal compatible representation for 11.2
49   FUNCTION compatible_11_2 RETURN INTEGER;
50 
51   -- internal compatible representation for 12.1
52   FUNCTION compatible_12_1 RETURN INTEGER;
53 
54   -- internal compatible representation for max_compatible
55   FUNCTION max_compatible RETURN INTEGER;
56 
57   -- Convert an XMLLCR object into a DML or DDL LCR encapsulated in AnyData.
58   FUNCTION convert_xml_to_lcr(xmldat sys.xmltype) RETURN SYS.ANYDATA;
59 
60   -- Convert a DML or DDL LCR encapsulated in an anydata into an
61   -- XMLLCR object.
62   FUNCTION convert_lcr_to_xml(anylcr sys.anydata) RETURN SYS.XMLTYPE;
63 
64 END dbms_streams;