ORA-00937 Errors While Executing A Query Using Microsoft OLEDB Drivers

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.4
Microsoft 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. You
will hit this bug if you are using Microsoft OLEDB drivers to connect to database with
CURSOR_SHARING=SIMILAR or FORCE.

Solution

Use CURSOR_SHARING=EXACT
or
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/