Skip to Content

Clob Data from Oracle losing Format for some and retaining for some Scenario??

Jan 16 at 01:18 PM


avatar image

Hi Gurus,

Its every urgent help I need.

I am extracting for oracle Clob(text-field)source-format-data.png filed into Long data-type field in BODS.

The strange thing is its retaining format(tabs,Sapces, Newlines )for maximum data but not for some 1% data. Has anyone experienced it before?

Source data : As shown in screen-shot.

As I import this table in BODS result is as shown(even after taking export in excel):

Import Table Data:

*** 2016-11-07 02:48 +0000 *** Kim, Sun Kyu/Samsung Electrpoonics Co Ltd:1148083 *** Rehost requested by (Kim, Sun Kyu/Samsung Electronics Co Ltd:1948083) Kim, Sun Kyu/Samsung Electronics Co Ltd:2048083 has agreed to the disclaimer shown on the Rehost License Request form The reason for rehost as supplied by Kim, Sun Kyu/Samsung Electronics Co Ltd:1048083: License server computer upgrade. The following Licenses have been selected for rehosting: Serial Number Duration Seats License Owner Host ID(s) 3P29T-54137-48164 N/A 2 Kim, Sun Kyu/Samsung Electrpa02454920d3e (PTHERNET).



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers