Hi.
We have a problem where fetching XMLType column data in 11.2.0.1 on Windows x64 was working fine, but we upgraded to 11.2.0.3 Patch 21 and the column type changed to binary storage as the default, and we started getting read errors when the data was larger than 32KB (or so it seems).
I opened an SR, and Oracle support sent me a VB script to test reading from the table over OleDB. However, their script did not seem to work as advertised, so after lots of gooling, we came up with the following to read a non-xmltype column from the same table, just to test that the vbscript works:
rem need to re-register OLEDB dll as there is a problem with oracle client and the dll registration
rem run following in an Administrative Command prompt
rem regsvr32.exe c:\Users\finite9\oracle\product\11.2.0\client_2\bin\oraoledb11.dll
set con = createobject("adodb.connection")
con.open "provider=oraoledb.oracle;user id=finite9;password=password1;data source=TSTDB"
set rs = createobject("adodb.recordset")
rs.open "select changedate from SW_REPLY",con
While Not rs.EOF
MsgBox rs.Fields("changedate").Value
rs.MoveNext
Wend
rs.close
set rs=nothing
con.close
set con=nothing
This works perfectly, and displays the 12 rows in that column in a vbscript dialogue box, but Im not able to get it to fetch clob data from the XMLType column. I try with eg. rs.open "select REPLYDATA.getclobval() from SW_REPLY",con but just get errors.
Is it possible to fetch XMLType data over OleDB with vbscript? It cannot be OleDB itself that is the problem because it has been working in our application and 11.2.0.1 albeit with <32kb data. But it would be nice to get a working test case so that we could test outside of our application. Whether that is with vbscript or C# doesn't really matter.