Skip to Main Content

ODP.NET having a boolean as a return or out throws ORA-06502

3027730Dec 1 2018 — edited Dec 2 2018

Hi,

I don't know if I am doing something wrong or what, but I've been unable to use ODP.NET to retrieve a boolean value, either through a function or a store procedure.

I've tried with a test function that just returns a boolean as well as a store procedure with boolean parameters in or in out, all of then throwed ORA-06502, sending booleans as in parameters works perfectly.

I've tested in all of the different ODP.NET versions: Unmanaged, Managed and Managed Core, all of then giving me the same result.

I am on 12.1.0.2.0 Enterprise.

Any help or guidance is appreciated.

Regards,

Comments
Post Details
Added on Dec 1 2018
7 comments
281 views