| General Information |
| Note:
DBMS_LCR contains opaque type definitions for sys.lcr$_row_record, sys.lcr$_ddl_record, and sys.lcr$_procedure_record |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmslcr.sql |
| Constants |
| Name |
Data Type |
Value |
| Constants for LOBs |
| 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 |
| 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_record |
| Security Model |
Execute is granted to PUBLIC |
|
