Home » RDBMS Server » Server Utilities » Error inserting images into table
Error inserting images into table [message #353039] Fri, 10 October 2008 13:37 Go to next message
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.
Re: Error inserting images into table [message #353052 is a reply to message #353039] Fri, 10 October 2008 14:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think you deserve your nickname.
From your previous post:
anacedent wrote on Thu, 10 July 2008 01:05
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

It seems you didn't learn how to format from the posted link.

Regards
Michel

Re: Error inserting images into table [message #353063 is a reply to message #353039] Fri, 10 October 2008 16:41 Go to previous messageGo to next message
live2learn
Messages: 34
Registered: February 2006
Member
Problem is resolved.

Closing this thread.
Re: Error inserting images into table [message #353081 is a reply to message #353063] Sat, 11 October 2008 01:03 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And you don't think that the solution you found may be of some help for others?
Please post it here.

Regards
Michel

[Updated on: Sat, 11 October 2008 01:04]

Report message to a moderator

Previous Topic: Using TRIM in sql loader control file
Next Topic: SQL Loader Question
Goto Forum:
  


Current Time: Sat Dec 03 01:14:52 CST 2016

Total time taken to generate the page: 0.08294 seconds