how to typecast a string field to clob/blob in oracle db using wemethods 8

, ,
1

my scenario:

I need to insert a huge xml file(it can be off any size) in to oracle table.
Do I need to need use glob/clob datatype for this field.
if yes,how to do typecasting of a string field to clob/blob.

is their any other better way than using clob/blob.

Please advice ?

2

I am not sure if this will work but try creating a column of type clob and then create a java service to convert a string to a clob value using the setCharecterStream method described at below URL.

map that object to the JDBC adapter input clob object and see if it works!

cheers,
Akshith

3

Review the JDBC Adapter User’s Guide. It defines the mappings the adapters support between CLOB/BLOB and Java data types.