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

[Message index]

		OWB:Loading clob data to a csv file (merged) By: DIPRINKS on Fri, 02 August 2013 10:41
		Re: OWB:Loading clob data to a csv file (merged) By: Michel Cadot on Fri, 02 August 2013 10:47
		Re: OWB:Loading clob data to a csv file (merged) By: helioswang on Tue, 11 March 2014 20:36
		Re: OWB:Loading clob data to a csv file (merged) By: painithin2000 on Fri, 14 March 2014 05:37
		Re: OWB:Loading clob data to a csv file (merged) By: painithin2000 on Fri, 14 March 2014 05:38

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 05:42:46 CDT 2024