Forum Stats

  • 3,781,158 Users
  • 2,254,484 Discussions
  • 7,879,596 Comments

Discussions

Problem Loading Word documents in BLOB columns

3004
3004 Member Posts: 204,171
Hi
I tried loading the documents in the BLOB column, then indexing and then text serach, but the query does not work or guess that the document does not get loaded
The table structure is
table: Content
feilds
id number (10) pk
author varchar2(30)
doc_name varchar2(60)
document BLOB default empty_blob()

loaded data with SQL loader and the file details are below

the load1.ctl file
--------
LOAD DATA
INFILE 'd:\intermedia\data1.dat'
INTO TABLE contents
APPEND
FIELDS TERMINATED BY ','
(id SEQUENCE (MAX,1),
author ,
doc_name
LOBFILE (CONSTANT 'c:\nandeep\jun_news.doc') TERMINATED BY EOF)
----------

data1.dat contents is as follows
------------------
nandeep,june news,c:\nandeep\jun_news.doc,

--------------------------

Any reason why it does not work or what could be the alternative

-nandeep

null

Comments

This discussion has been closed.