Home » Developer & Programmer » Data Integration » Error while importing an external table.
icon1.gif  Error while importing an external table. [message #262593] Mon, 27 August 2007 13:28 Go to next message
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 2080 times)
Re: Error while importing an external table. [message #262666 is a reply to message #262593] Tue, 28 August 2007 01:00 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: Error while importing an external table. [message #262717 is a reply to message #262666] Tue, 28 August 2007 02:22 Go to previous message
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.
Previous Topic: How to run a mapping in WAREhouse bUILDER 10 g
Next Topic: Does Oracle Database 10g Express Edition Support XSU?
Goto Forum:
  


Current Time: Thu Mar 28 07:06:09 CDT 2024