Oracle XMLtype data type

[Former Member]

Latest Powerbuilder 12.5.2

Oracle 11g

How can I update a XMLType column?

can select it, but errors on update.

[Former Member]

In the PowerBuilder help under datatypes > Oracle it shows the following for the XMLType:

XMLType (partial support, ORA driver only)

The ORA driver adds support for the XMLType datatype that was introduced with Oracle 9i. However, you cannot use this datatype with embedded SQL statements or in a DataWindow object.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc37776.1252/html/connpb/BH...

[Former Member]

I read that too, so it is limited support i.e. 4000 characters. Very limited for XML data.

I'm out of ideas

[Former Member]

Hi David;

  Why not just use a Long Raw column and the Select/Update Blob commands?

Regards .. Chris