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
XMLType Fields
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).
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).