ITPub博客

首页 > 数据库 > Oracle > ORA-3115 "unsupported network datatype or representation" BINARY_DOUBLE

ORA-3115 "unsupported network datatype or representation" BINARY_DOUBLE

原创 Oracle 作者:aimospang 时间:2015-08-04 16:46:43 0 删除 编辑
今天,有个同事在查询含有BINARY_DOUBLE数据类型的字段的表时,报错,报:ORA-3115 "unsupported network datatype or representation",同事用的是PLSQL DEVELOPER,版本是10.0的版本,最后经过metalink和百度,发现很可能是安装的oracle的软件版本过低,后来一看,果然,他安装的是9i的客户端软件,随后帮他把9i客户端卸载掉,然后安装10g的客户端软件,最后再次查询,问题解决,当然64位的windows 7安装plsql developer软件需要小费一番周折,不管不麻烦,就几步而已。可以参考我的另一篇文章。
metalink上关于ORA-3115的文档如下:
OERR: ORA-3115 "unsupported network datatype or representation" Reference Note (文档 ID 19792.1)

Purpose

This is a brief reference note to show the meaning of database error "ORA-3115". It includes the error text, "Cause" and "Action" from message files for each database version from 9.2 onwards, along with search links and details of any database bug issues related to the error.

Scope

This note is intended for general audience as a starting point to check the meaning of "ORA-3115". It does not give detailed information about the error and does not give error message text for versions below 9.2 .

Details

Error Text, Cause and Action from Message File/s for ORA-03115

Versions 9.2, 10.1, 10.2, 11.1, 11.2, 12.1 Error: ORA-03115 unsupported network datatype or representation 
--------------------------------------------------------------------------- Cause: Action: 

Search Links for ORA-03115

The links below can be used to locate ORA-3115 in the documentation, and to search for documents that give more information about the error.

Database Bugs Related to ORA-03115

Errors are usually due to usage, application or configuration issues but in some cases they may be caused by a bug issue. This section lists any database bugs that have been linked to error "ORA-3115" .





NB Bug Fixed Description

1834732 9.2.0.4, 10.1.0.2 JDBC thin fails with ORA-3115 while trying to fetch a UROWID

1803897 9.2.0.2, 10.1.0.2 Bad define conversions may fail with ORA-3115 rather than ORA-932

3880708 9.2.0.7 ORA-3001 / ORA-3115 inserting in gateway table from 8i -> 9i -> gateway

2517719 9.2.0.3, 10.1.0.2 ORA-3115 from setTimestamp() in JDBC 9.2 with an 8.0 database

2118014 9.0.1.3, 9.2.0.1 ORA-03115 from JDBC thin describing a table containing a TIMESTAMP based datatype

1753705 9.0.1.1, 9.2.0.1 OERI:7005 / ORA-3115 querying an internal ROWID from a table

695389 8.0.4.3, 8.0.5.1, 8.0.6.0 ORA-3115 replicating BLOB columns between machines

850888 8.1.5.1, 8.1.6.0 ORA-3115 using TIME datatype between 32 to 64 bit connections

920055 8.1.5.1 ORA-3115 from OCI8 fetches between NT and UNIX platforms
  • '*' indicates that an alert exists for that issue.
  • '+' indicates a particularly notable issue / bug.
See Note:1944526.1 for details of other symbols used

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28811352/viewspace-1761695/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-04-16

  • 博文量
    8
  • 访问量
    20895