Home » Developer & Programmer » JDeveloper, Java & XML » JDeveloper Text Wizard Problem [loader.ctl]
JDeveloper Text Wizard Problem [loader.ctl] [message #138773] |
Fri, 23 September 2005 08:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
herry.roby
Messages: 10 Registered: September 2005
|
Junior Member |
|
|
Hi all,
Does anyone know how to create ‘loader.ctl’ to load documents such as HTML, PDF, and TXT which using ORDDOC?
I tried to build Text Search Application using ORDDOC type with JDeveloper Text Wizard and have an error when I load ‘loader.ctl’ using SQL*Loader. Below is my code:
Rem=============================================================
Rem CREATE TABLE po_products (
Rem product_id NUMBER NOT NULL CONSTRAINT pp_pk PRIMARY KEY
Rem , product_name VARCHAR2(100) NOT NULL
Rem , description VARCHAR2(500)
Rem , price NUMBER NOT NULL
Rem , filename VARCHAR2(80)
Rem , document ORDSYS.ORDDOC
Rem )
Rem=============================================================
LOAD DATA
INFILE *
CONTINUEIF NEXT(1) = '+'
INTO TABLE po_products
INSERT
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(
product_id SEQUENCE(100,1),
price POSITION(1),
product_name CHAR,
description CHAR(500),
filename CHAR,
document COLUMN OBJECT
(
Mimetype,source COLUMN OBJECT
(
localData_fname FILLER CHAR(12),
localData LOBFILE (document.source.localData_fname) RAW TERMINATED BY EOF
)
)
)
BEGINDATA
"3000.00","Oracle Database Enterprise Edition",
+"Oracle Database Enterprise Edition.",
+"o8i_ee.html", "o8i_ee.html"
"1200.00","Advanced Security Option",
+"ASO bundles value-added security services for Oracle DB.",
+"advsec.html","advsec.html"
"2500.00", "Oracle Internet Application Server Enterprise",
+"Oracle9i Application Server.",
+"ias_content.html", "ias_content.html"
"500.00", "Oracle Internet Developer Suite",
+"Oracle Internet Developer Suite.",
+"ids_content.html", "ids_content.html"
Result:
SQL*Loader-416: SDF clause for field LOCALDATA in table PO_PRODUCTS references a non existent field.
When
document COLUMN OBJECT
(
Mimetype,source COLUMN OBJECT
(
localData_fname FILLER CHAR(12),
localData LOBFILE (document.source.localData_fname) RAW TERMINATED BY EOF
)
Replaced with
document_fil FILLER CHAR,
document LOBFILE (document_fil) TERMINATED BY EOF
Error Message show:
SQL*Loader-418: Bad datafile datatype for colomn DOCUMENT
I’m newbie with ORDSYS.ORDDOC.
Does anyone can help me please?
Thanks,
Herry
|
|
|
|
Goto Forum:
Current Time: Mon Sep 09 08:55:33 CDT 2024
|