ORA-00903/ORA-0937 Errors While Executing A Query Using Microsoft OLEDB Drivers [ID 462734.1] | |||||
修改时间 15-OCT-2007 类型 PROBLEM 状态 MODERATED |
In this Document
Symptoms
Cause
Solution
References
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review. |
Applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 10.2.0.4Microsoft Windows
Symptoms
You are using Microsoft OLEDB drivers and queries executed from application throws ORA-00903 or ORA-00937 with CURSOR_SHARING=FORCE or SIMILAR. It works fine from application with CURSOR_SHARING=EXACT.The query also runs fine from SQL*Plus irrespective of CURSOR_SHARING parameter value.
Cause
Errors are due to Bug 1988231 . The issue is with underlying Microsoft OLEDB drivers. Youwill hit this bug if you are using Microsoft OLEDB drivers to connect to database with
CURSOR_SHARING=SIMILAR or FORCE.
Solution
Use CURSOR_SHARING=EXACTor
Use Oracle ODBC Driver
References
BUG:1988231 - VISUAL BASIC EXES GET ORA-937 W/CURSOR_SHARING=FORCE, OK W/CURSOR_SHARING=EXACT来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-711610/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-711610/