Unable to use XMLType

nschmied · Post by **nschmied** » Wed 05 Oct 2005 06:43

Hello,
It's still me

This time I have a problem with XMLType.

1. Create a table with XMLType

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.

nschmied · Post by **nschmied** » Wed 05 Oct 2005 08:47

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 !!!

Alex · Post by **Alex** » Wed 05 Oct 2005 09:22

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.

nschmied · Post by **nschmied** » Wed 05 Oct 2005 09:26

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,

Alex · Post by **Alex** » Thu 06 Oct 2005 11:55

We have reproduced your request and fixed it. This fix will be included in the next ODAC build.

nschmied · Post by **nschmied** » Thu 06 Oct 2005 13:20

Thanks

nschmied · Post by **nschmied** » Tue 18 Oct 2005 06:24

Hello,
I have tested your new build. Now read XMLTYPE with Oracle10g work fine, But........ it's not unicode ????