Home » Developer & Programmer » Warehouse Builder » OWB:Loading clob data to a csv file (merged) (OWB 11.2.0.3)
OWB:Loading clob data to a csv file (merged) [message #592047] Fri, 02 August 2013 10:41 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58523
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not multipost your question in several forums.

Regards
Michel
Re: OWB:Loading clob data to a csv file (merged) [message #609752 is a reply to message #592047] Tue, 11 March 2014 20:36 Go to previous messageGo to next message
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.
Re: OWB:Loading clob data to a csv file (merged) [message #609936 is a reply to message #609752] Fri, 14 March 2014 05:37 Go to previous messageGo to next message
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
Re: OWB:Loading clob data to a csv file (merged) [message #609937 is a reply to message #609936] Fri, 14 March 2014 05:38 Go to previous message
painithin2000
Messages: 10
Registered: October 2013
Location: Bangalore
Junior Member
Still getting attached error message. I am using basic edition of OWB 11gR2
Previous Topic: Parallel objects on a mapping
Next Topic: Oracle Metadata Builder
Goto Forum:
  


Current Time: Thu Jul 24 04:09:22 CDT 2014

Total time taken to generate the page: 0.09379 seconds