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 126.96.36.199.0 Enterprise.
Any help or guidance is appreciated.