on ‎2014 May 22 2:38 PM
Latest Powerbuilder 12.5.2
Oracle 11g
How can I update a XMLType column?
can select it, but errors on update.
Hi Robert;
I have not personally done this with Oracle .. but, my guess is that you may need to use the UpdateBlob command.
BTW: What error(s) are you getting?
Regards ... Chris
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I already tried that.
If data string size is under 4k it works fine. If data is over 4k I get...
ORA-01461: can bind a LONG value only for insert into LONG column.
How are you connecting to Oracle ... via ODBC?
No, ODBC will not let me even select the column. I am using ORA Oracle. It has the Metadata Type XMLType.
BTW UpdateBlob errors with....
SELECTBLOB/UPDATEBLOB is valid only for LONG, RAW and LONG RAW datatypes. (108)
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.