JDBC RECEIVER ADAPTER ORACLE BLOB / CLOB

[ralf_zimmerningkat3]

Hello all,

I have to send any images form SAP PI to Oracle Database.

Because I have to map the input data i change the image to base64 and put it into the payload.

Using an insert to oracle with the jdbc adapter failed due tu oracle limits of the sql parser. sql parser could only

handle values <4k.

database filed in oracle is of type clob so it can handle up to 4 gig, but now way to insert using the jdbc adapter?

Any hints ??

Regards

Ralf

[rajasekhar_reddy14]

Hi,

If it is Clob type in Data base we can insert in to data base,But i am not sure its possbile using JDBC Adapter,But i had done using JAVA Mapping few month back ,at mapping level only i inserted data.

i think we can do it using JDBC Adapter also,but it depeds on how you writetn query.

Regards,

Raj

[ralf_zimmerningkat3]

Hi Raj,

have you an example of filling the database CLOB from java mapping?

[rajasekhar_reddy14]

Hi,

its stabndard procedre only like JDBC Lookup,if you want code what i have writen i wl forward.rajasekhar84 goooglemai

But its not betetr approch to perform stateful operation from JAVA Mapping.

Regards,

raj