OraFAQ Forum: Data Integration » Error while importing an external table.

Home » Developer & Programmer » Data Integration » Error while importing an external table.

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

Error while importing an external table. [message #262593]

Mon, 27 August 2007 13:28

ramya.pathak
Messages: 15
Registered: August 2007

Junior Member

Hi all,

Am getting the following error while impoting an external table through Oracle Warehouse Builder 10.2:-

SQL Exception
SQL Exception
Repository Error:SQL Exception..
Class Name: CacheMediator.
Method Name: getDDEntryFromDB.
Repository Error Message: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4660, maximum: 4000)
--Complete error log attached.--

I have created the External table through SQL Plus. Its a fixed length format table with record delimited by newline.
The length of one record is 522 bytes. All datatypes used in External table defination are CHAR.

Help required..

Thanks in advance..

Attachment: OWB Error.txt
(Size: 1.57KB, Downloaded 2632 times)

Report message to a moderator

Re: Error while importing an external table. [message #262666 is a reply to message #262593]

Tue, 28 August 2007 01:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm sorry, I wouldn't know why OWB returned an error.

As a workaround, why wouldn't you load data using SQL*Plus (and external tables feature), or a simple SQL*Loader session?

Report message to a moderator

Re: Error while importing an external table. [message #262717 is a reply to message #262666]

Tue, 28 August 2007 02:22

ramya.pathak
Messages: 15
Registered: August 2007

Junior Member

The requirement is such that we need to use only OWB.
I tried to reduce the number of columns in this external table and it worked fine. I think there is some problem with the total length of the source text file. The source file is of 522 bytes length. And number of columns are 95.

Report message to a moderator

Previous Topic:	How to run a mapping in WAREhouse bUILDER 10 g
Next Topic:	Does Oracle Database 10g Express Edition Support XSU?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 18:44:48 CST 2025