![]() ![]() ![]() But it would be nice to get a working test case so that we could test outside of our application. ![]() 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. rs.open "select REPLYDATA.getclobval() from SW_REPLY",con but just get errors. 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. Rs.open "select changedate from SW_REPLY",con Set con = createobject("nnection")Ĭon.open "provider=oraoledb.oracle user id=finite9 password=password1 data source=TSTDB" Rem regsvr32.exe c:\Users\finite9\oracle\product\11.2.0\client_2\bin\oraoledb11.dll Rem run following in an Administrative Command prompt Rem need to re-register OLEDB dll as there is a problem with oracle client and the dll registration 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: I opened an SR, and Oracle support sent me a VB script to test reading from the table over OleDB. We have a problem where fetching XMLType column data in 11.2.0.1 on Windows 圆4 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). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |