Oracle DBMS_LCR
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose DBMS_LCR contains opaque type definitions for sys.lcr$_row_record, sys.lcr$_ddl_record, and sys.lcr$_procedure_record
AUTHID N/A
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
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved