Devart Forums

Hi ,

is there a way to handle a XMLTYPE Column like an CLOB Column, so that it could be edited.

Greetings and thanks
Jens

You can use the CLOB_VAL method of XMLTYPE in your SELECT statement. But you need to assign to the SQLInsert and SQLUpdate properties statements that write a value of a CLOB field to the database.

Did you have a sample for the insert / update statements.

The table could look like:

create table xml_test (data xmltype);

Greetings
Jens

INSERT INTO xml_test(id, data) VALUES(:id, XMLTYPE(:data))

UPDATE xml_test SET id = :id, data = XMLTYPE(:data)
WHERE id = :old_id

(You need to add ID field to the table for UPDATE statement.)

Thanks,

but why isn't it possible to handle the xmltype like a clob column.

In the allroundautomations components there is no problem with the xmltype columns.

Greetings
Jens

We'll consider possibility to implement handling XMLTYPE using CLOB.