ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
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;
/
