Managed ODP.NET Provider Fails With ORA-1008 Error While Executing SELECT Statement With Single Quote And Bind Variable
(Doc ID 2169794.1)
Last updated on JANUARY 29, 2022
Applies to:Oracle Data Provider for .NET - Version 126.96.36.199 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
Managed ODP.NET provider throws "ORA-1008 not all variables bound" error, while executing a SELECT statement which includes single quoted string constant and bind variable.
Issue can be reproduced using the below code.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document