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

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 ?

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!


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