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

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

Applies to:

Symptoms

Cause

Solution

References