OraFAQ Forum: JDeveloper, Java & XML » JDeveloper Text Wizard Problem [loader.ctl]

Home » Developer & Programmer » JDeveloper, Java & XML » JDeveloper Text Wizard Problem [loader.ctl]

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

JDeveloper Text Wizard Problem [loader.ctl] [message #138773]

Fri, 23 September 2005 08:58

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

Report message to a moderator

Re: JDeveloper Text Wizard Problem [loader.ctl] [message #146269 is a reply to message #138773]

Wed, 09 November 2005 11:46

abramia
Messages: 9
Registered: November 2005
Location: Israel

Junior Member

Herry,
Did you try the JDeveloper forum?

Good Luck,
Avi.

Report message to a moderator

Previous Topic:	Using a Visual Basic-DLL within Oracle
Next Topic:	JDK 1.4 : classes12 or ojdbc14

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 17:55:27 CST 2024