CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [218 users online]    © 2010 psoug.org