$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << Oracle DBMS_LCR Version 11.1  
General
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
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;
/
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
Dependencies lcr$_row_record
Security Model Execute is granted to PUBLIC
 
Related Topics
DBMS_LOB
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>