Oracle DBMS_LCR
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
 LOB Constants
not_a_lob NUMBER 1
null_lob NUMBER 2
inline_lob NUMBER 3
empty_lob NUMBER 4
lob_chunk NUMBER 5
last_lob_chunk NUMBER 6
 LONG Data Type Constants
not_a_long NUMBER 1
null_long NUMBER 2
inline_long NUMBER 3
long_chunk NUMBER 4
last_long_chunk NUMBER 5
 XML Constants
 not_xml NUMBER 1
xml_doc NUMBER 2
xml_diff NUMBER 3
 JSON Constants
not_oson NUMBER 1
oson_doc NUMBER 2
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
What's New In 19c
What's New In 20c-21c

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