OraFAQ Forum: Data Integration » OWB:Loading clob data to a csv file (merged)

Home » Developer & Programmer » Data Integration » OWB:Loading clob data to a csv file (merged) (OWB 11.2.0.3)

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

OWB:Loading clob data to a csv file (merged) [message #592047]

Fri, 02 August 2013 10:41

DIPRINKS
Messages: 57
Registered: July 2013
Location: Michigan

Member

I want to load a table having clob column into a flat file using owb.I have created a simple mapping with source as the database table and the target a the flat file(csv).When I run this mapping,I get the error :
ORA-06502:pl/sql:numeric or value error:character string buffer too small

Can you please suggest how to create a flat file from a table containing clob data using owb and how to get rid of this error?
Thanks.

[Updated on: Fri, 02 August 2013 10:46] by Moderator

Report message to a moderator

Re: OWB:Loading clob data to a csv file (merged) [message #592048 is a reply to message #592047]

Fri, 02 August 2013 10:47

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do not multipost your question in several forums.

Regards
Michel

Report message to a moderator

Re: OWB:Loading clob data to a csv file (merged) [message #609752 is a reply to message #592047]

Tue, 11 March 2014 20:36

helioswang
Messages: 1
Registered: March 2014

Junior Member

You can set the data type of the corresponding column in the CSV file as CLOB. Set the data type in the mapping not in the file structure.

Report message to a moderator

Re: OWB:Loading clob data to a csv file (merged) [message #609936 is a reply to message #609752]

Fri, 14 March 2014 05:37

painithin2000
Messages: 10
Registered: October 2013
Location: Bangalore

Junior Member

Hi, I tried with target file datatype as CLOB.
And its a simple mapping source table to target file.
Only 3 columns from source table are mapped to Target file.
1 column with datatype as number and other 2 with datatype CLOB

Attachment: CLOB_IN_TARGET_FILE_ERROR.jpg
(Size: 55.07KB, Downloaded 3786 times)

Report message to a moderator

Re: OWB:Loading clob data to a csv file (merged) [message #609937 is a reply to message #609936]

Fri, 14 March 2014 05:38

painithin2000
Messages: 10
Registered: October 2013
Location: Bangalore

Junior Member

Still getting attached error message. I am using basic edition of OWB 11gR2

Report message to a moderator

Previous Topic:	Parallel objects on a mapping
Next Topic:	Oracle Metadata Builder

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 13 10:03:47 CST 2025