Page 1 of 1

Unable to use XMLType

Posted: Wed 05 Oct 2005 06:43
by nschmied
Hello,
It's still me ;)

This time I have a problem with XMLType.

1. Create a table with XMLType

Code: Select all

CREATE TABLE TEST_CLOB
(
  MY_CLOB_ID  NUMBER(12),
  MY_CLOB     CLOB,
  MY_XML      SYS.XMLTYPE
)
And with the ODAC demo Query.exe use this

Code: Select all

select * from test_clob
And click "OPEN".

At this time have recive a Error box with this text :
Unable to find an entry ppoint named OCIPStreamFromXMLType10 in DLL oci.dll
I have last ODAC 5.55.1.3022 and Oracle 10.0.2

In made it is the continuation of my try to be able to read my CLOB. :wink:

Posted: Wed 05 Oct 2005 08:47
by nschmied
I have make some change in OraCall file

Code: Select all

XXXXXXXXXXXXX
And OraCallCLR

Code: Select all

XXXXXXXXXXXXX
Now I can read a XMLType, but now AsString don't support Unicode !!!

Posted: Wed 05 Oct 2005 09:22
by Alex
We will review your solution, but please don't post ODAC source pieces on the forum. In case you need to discuss the souces you can do it with ODAC support team via e-mail.

Posted: Wed 05 Oct 2005 09:26
by nschmied
Alex wrote:We will review your solution, but please don't post ODAC source pieces on the forum. In case you need to discuss the souces you can do it with ODAC support team via e-mail.
OK Sorry, :(

Posted: Thu 06 Oct 2005 11:55
by Alex
We have reproduced your request and fixed it. This fix will be included in the next ODAC build.

Posted: Thu 06 Oct 2005 13:20
by nschmied
Thanks 8)

Posted: Tue 18 Oct 2005 06:24
by nschmied
Hello,
I have tested your new build. Now read XMLTYPE with Oracle10g work fine, But........ it's not unicode ????