SQLLDR - CLOB Data Load
--Reference Table structure

SQL> desc BI_Reports_Framework
 Name                          Null?    Type
 ----------------------------- -------- -----------------  
 REPORT_ID                     NOT NULL NUMBER
 REPORT_TYPE                   NOT NULL VARCHAR2(100)
 TEMPLATE_NAME                 NOT NULL VARCHAR2(50)
 REPORT_DESCRIPTION                     VARCHAR2(100)
 USER_GROUP                             VARCHAR2(50)
 REPORT_FRAMEWORK              NOT NULL CLOB
 REPORT_STATUS                 NOT NULL VARCHAR2(1)
 CREATED_DATE                  NOT NULL DATE

SQL> 

Note: The report_id column is populated by a trigger 
(similar to one shown in auto numbering trigger).
SQLLDR - CLOB Data Control File (bireportsfw.ctl)
-- bireportsfw.ctl
OPTIONS (BINDSIZE=2097152, READSIZE=2097152)
LOAD 
INFILE 'bireportfw.txt' "str '***'"
BADFILE 'bireportfw.bad' 
DISCARDFILE 'bireportfw.dis'
APPEND INTO TABLE BI_Reports_Framework
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY "'"
TRAILING NULLCOLS
(
 report_type         CHAR,
 template_name       CHAR,
 report_description  CHAR,
 user_group          CHAR,
 report_framework    CHAR(60000),
 report_status       CONSTANT "Y"
)


Refer: - CLOB (Oracle 11g)

Oracle registered trademark of Oracle Corporation.

Last Revised on: February 24th, 2012

  452