hi gurus,

I have one table and with three colums like file_id,file_name,file_data. i want to upload data from external files like .txt,.doc,.pdf files to this talbe. After running sql loader i am getting errors like

C:\>sql*loader-646: LOB set to EMPTY in column data.

commit point reached - logical records count 4.

In log file it shows error:

sql*loader -0146: unimplemented or unconversional ...error.

i tring to find out, but still not yet cleared. can any one help me out.

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

Table:
------
CREATE TABLE image_table (
file_id NUMBER(5),
file_name VARCHAR2(30),
file_data CLOB);

-------
Control file:
-------------
LOAD DATA
INFILE *
INTO TABLE image_table
APPEND
FIELDS TERMINATED BY '|' trailing nullcols
(
file_id INTEGER(5),
file_name FILLER CHAR(30),
file_data LOBFILE (file_name) TERMINATED BY EOF
)
BEGINDATA
10|c:\a.txt
20|c:\b.doc
------------
a.txt file contents:
-------------------
This is text file only.

b.doc file contents:
--------------------
This is doc file only.

Actually i am looking the info like

file_id file_name file_data
------------------------------------------
10 a.txt This is text file only.
20 b.doc This is doc file only.

Expecting an early response from all who has interested to solve this problem.

Seshi