converter from varchar to clob

[former_member199541]

Hi ,

I have simple sql statement need to be executed:

update os_propertyentry

set text_val=string_val

where key_type = 5

the problem is that i get an error :

=> Error Executing 'update os_propertyentry set text_val=string_val where key_type = 5 ...' SAP DBTech JDBC: [-7032] (at 43): SQL statement not allowed for column of data type LOB:TEXT_VAL

this is happens because text_val is define as clob and string_val is varchar(255).

How can i make my update statement working ?

Thanks,

Ido

[lbreddemann]

You've to be careful with data types here.

There is no build-in text to (c)lob conversion in MaxDB.

If you want to do something like this, you've to do it on client side.

This is also documented [UPDATE|http://maxdb.sap.com/doc/7_8/45/40635b6c6c4002e10000000a155369/frameset.htm].

Scroll down to "Data Type LOB" !

regards,

Lars