Oracle DBMS_LCR
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Purpose DBMS_LCR contains opaque type definitions for sys.lcr$_row_record, sys.lcr$_ddl_record, and sys.lcr$_procedure_record
AUTHID DEFINER
Constants
Name Data Type Value
Constants for LOBs
not_a_lob CONSTANT NUMBER := 1; NUMBER 1
null_lob NUMBER 2
inline_lob NUMBER 3
empty_lob NUMBER 4
lob_chunk NUMBER 5
last_lob_chunk NUMBER 6
Constants for LONGs
not_a_long NUMBER 1
null_long NUMBER 2
inline_long NUMBER 3
long_chunk NUMBER 4
last_long_chunk NUMBER 5
Constants for XML
 not_xml NUMBER 1
xml_doc NUMBER 2
xml_diff NUMBER 3
Data Types CREATE OR REPLACE TYPE lcr$_row_unit AS OBJECT (
column_name        VARCHAR2(4000),
data               SYS.ANYDATA,
lob_information    NUMBER,
lob_offset         NUMBER,
lob_operation_size NUMBER,
long_information   NUMBER,
-- as we are adding a new attribute, create a constructor for
-- older type def to preserve backwards compatibility.
CONSTRUCTOR FUNCTION lcr$_row_unit(
column_name        VARCHAR2,
data               SYS.ANYDATA,
lob_information    NUMBER,
lob_offset         NUMBER,
lob_operation_size NUMBER)
RETURN SELF AS RESULT);
/

CREATE OR REPLACE TYPE BODY lcr$_row_unit AS
CONSTRUCTOR FUNCTION lcr$_row_unit(
column_name        VARCHAR2,
data               SYS.ANYDATA,
lob_information    NUMBER,
lob_offset         NUMBER,
lob_operation_size NUMBER)
RETURN SELF AS RESULT AS
  BEGIN
    SELF.column_name := column_name;
    SELF.data := data;
    SELF.lob_information := lob_information;
    SELF.lob_offset := lob_offset;
    SELF.lob_operation_size := lob_operation_size;
    SELF.long_information := dbms_lcr.not_a_long;
    RETURN;
  END;
END lcr$_row_unit;
/

CREATE OR REPLACE TYPE lcr$_row_list AS TABLE OF sys.lcr$_row_unit;
/
Dependencies
LCR$_ROW_UNIT    
Documented No
First Available Not known
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/dbmslcr.sql

Related Topics
DBMS_LOB
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_AUTH
DBMS_STREAMS_TABLESPACE_ADM
Packages
Streams Demo 1

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved