Errors when opening tables with certain column types in ODAC 5.80

rmovchan · Post by **rmovchan** » Tue 25 Sep 2007 01:40

I'm getting two types of Oracle errors every time when trying to open tables with various datatypes. First error is ORA-03115: unsupported network datatype or representation. It occurs on a table containing only BINARY_FLOAT and BINARY_DOUBLE columns. Second error is OCI-21500: internal error code, arguments: [koiocon: opq], [], [], ...
It occurs on a table containing lots of various datatypes including ANYDATA and ANYTYPE. I can provide you with SQL for creating these tables. It worked OK with earlier versions of ODAC. I'm using ODAC 5.80.0.35 and Oracle 10g.

Thanks,
Roman

Plash · Post by **Plash** » Tue 25 Sep 2007 07:47

The error with BINARY_FLOAT and BINARY_DOUBLE types can occur if you use an old version of the Oracle client. You should use Oracle client 10.2 to work with these data types.

ODAC does not support ANYDATA and ANYTYPE types. Please specify the exact ODAC version where you can open a table with these data types without errors.

rmovchan · Post by **rmovchan** » Tue 25 Sep 2007 23:13

Thank you, you are exactly right. The problem occurs on 9 client. It appears that the older version was tested on 10.2 client, that's why it worked.

I'm not saying that we work with ANYTYPE or ANYDATA columns, all I'm asking for is ability to open a table that contains such columns. This works to me.

Thank you,
Roman