No Data Is Returned When Binding String Parameter With ODP.NET And SqlDataSource

(Doc ID 835912.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Data Provider for .NET - Version: 10.2.0.1.0 and later   [Release: and later ]

Symptoms

You are attempting to use ODP.NET 10.2 with a VS.NET SqlDataSource and string bind parameter.  When using the MS.NET provider it works fine.  If you switch to the Oracle Data Provider for .NET (ODP.NET) it returns no data and no error message.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms