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

tolywang發表於2010-11-17
ErrorWhileROS
ORA-00903/ORA-0937 Errors While Executing A Query Using Microsoft OLEDB Drivers [ID 462734.1]
  修改時間 15-OCT-2007     型別 PROBLEM     狀態 MODERATED  

In this Document
  
  
  
  

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 . 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

- VISUAL BASIC EXES GET ORA-937 W/CURSOR_SHARING=FORCE, OK W/CURSOR_SHARING=EXACT

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/35489/viewspace-711610/，如需轉載，請註明出處，否則將追究法律責任。

相關文章