Open imetallica opened 5 years ago
What is the "Oracle docker image"?
I'm expecting there is some kind of interface mismatch between the Oracle Core and .NET Full drivers, so the assumption of replacing the dll is not enough. ("Oracle.ManagedDataAccess.dll" vs "Oracle.DataAccess.dll")
@Thorium this docker image: https://hub.docker.com/_/oracle-database-enterprise-edition
@imetallica, I haven't looked at this using your Gist and Docker image, but have experienced a similar issue myself.
In my case, it occurred when I had two objects in the database, in the same schema that had the same name, but different case - for example, "Employee" and "EMPLOYEE".
You might also want to consider whether there is any issue related to when your user see original object in the user's schema, as well as a public synonym of the same name. (Although I did not replicate the issue that way in my environment.)
In any case, for your example stack trace above, based on the part that says "name = 'get_Col'", I would suggest that running the query may shed some light:
select object_type, owner, object_name from all_objects where upper(object_name) = 'COL';
Example output on a clean database install would be something similar to this:
Unless you have a very specific need to do so, I would never have an application connecting to the database using SYS as SYSDBA, as you have in the Gist. If you create a user with the relevant permissions to do just what it needs to do, and only grant the schema objects that it needs access to, then you will probably find that you do not encounter this issue.
Description
When doing simple queries on some oracle tables, the TP raises an exception
Repro steps
Use Oracle Docker Image
Use the following gist as a project: https://gist.github.com/imetallica/0dff42841a7273c61fd7149ea0e42e8d
Actual behavior
This is the exception it raises
Known workarounds
Not that I'm aware
Related information