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 · Accepted solution]

I am looking into the PBNI interface to see if the XML is > 4K then I will update the column via a C dll.  As long as the database connection is available, I should be able to get it to work.

First time looking at the PBNI.

[Former Member · Accepted solution]

As long as you're going to be playing with C++ you might just create a simple DLL.  You can pass in the handle of the PowerBuilder database connection to the DLL so you can do the work in the same connection.

I took the same approach to hiding the SET ROLE statement from the DB Trace log, by creating a DLL that issues that and calling that from PB right after the initial connect.  The last part of the following article explains that:

http://oracle.sys-con.com/node/927244

And the source code for the DLL is on CodeXchange (the article has the link).  Look for the "DBHandle demo" file.

[Former Member · Accepted solution]

Thank you Bruce for the help!