Devart Forums

Hi,

I have to work with xmlType fields.
Is there a possibility to handle them for select, insert and update in queries? The type doesn't seem to be supported directly (Unknown data type (116) (d:\Projects\Delphi\Dbx\Source\dbexp.pas, line 2131)
If yes, a sample would be great

thanks and best regards

gad

DbxOda does not support XMLTYPE fileds. But you can work with them using CLOB. For example:

SELECT t.xml_col.getclobval() FROM xml_table t

You can insert a value to XMLTYPE field using string parameter:

INSERT INTO xml_table (id, xml_col) VALUES (1, XMLTYPE(:p))

Set the DataType property of the P parameter to ftString. You also need to set the Size property of the parameter to a value that is large enough (the maximum size of string parameter is about 30000).

Hi,

Thanks a lot for your really quick answering.

It works!

I tried the select without the alias before. It never worked. Why do I have to use the alias? Is it wise to always base on aliases with DbxOda?

Best Regards and thanks

gad

This is the Oracle SQL syntax. You should use an alias if you call a method for an object type field.