Error inserting images into table [message #353039] |
Fri, 10 October 2008 13:37 |
live2learn
Messages: 34 Registered: February 2006
|
Member |
|
|
Hi All,
I am trying to insert images into a table.
Followed these steps:
CREATE TABLE XX_DEMO_IMG_TBL
(
file_id NUMBER(5),
file_name VARCHAR2(30),
file_data BLOB
);
LOAD DATA
INFILE *
REPLACE
INTO TABLE XX_DEMO_IMG_TBL
FIELDS TERMINATED BY ','
(
file_id INTEGER(5),
file_name FILLER CHAR(30),
file_data LOBFILE (file_name) TERMINATED BY EOF
)
BEGINDATA
1,c:\1.txt
used sqlldr cmd
Got the following error:
*ecord 1: Rejected - Error on table XX_DEMO_IMG_TBL.
ORA-01460: unimplemented or unreasonable conversion requested*
I am using *SQL*Plus: Release 10.2.0.3.0 -*
Can any one please guide where am i going wrong ?
Thanks.
|
|
|
|
|
|