Cannot load Oracle 19c tables to map

[Jay_Gregory]

I was provided connection details to a non-spatial Oracle DB.  I can create the connection (sde) file and see the list of tables, however if I right click on a table and choose Add To Current Map, I get the error:

Failed to add data: C:\Users\...\dbconnection.sde\SCHEMA.NAME.  DBMS table not found[ORA-00942: table or view does not exist].

Strangely, I am able to use Python search cursor to traverse the table programmatically, and arcpy.TableToTable_conversion will successfully export the data to a local geodatabase.  But what I want to do is add the table to a map so I can publish it to my ArcGIS Enterprise environment. (next step will be to register database as a datastore on Enterprise but this is the first step of course) 

I have checked with the DBA, and seem to have the correct permissions (CREATE_SESSION and SELECT.  Have also loaded the Oracle drivers (OracleDatabaseInstantClient19c) to my windows machine and added location to my path. Any ideas here what could be happening.  

[George_Thompson]

what is the schema of the table look like?

Wonder if there is a field that is causing an error via Pro UI.

[Jay_Gregory]

This is happening for multiple tables in the DB (probably all but there are hundreds).  One table that is it happening with just has BOOKMARK_ID_N and POSITION_VC as a Long and Text field respectively.  

[George_Thompson]

That is weird. I do not have any other ideas, sorry.

[VinceAngelo]

Does "Long" really mean "LONG"? LONG is not a supported Oracle type.

Do a DESCRIBE in SQL*Plus and report that here (you can redact the actual column names, but don't alter the types).

- V

[Jay_Gregory]

I unfortunately do not know how to access the tables outside of Pro (not a DBA 🙂

Here is a screenshot from Pro though

[CraigSwisher]

There are a couple of Esri Oracle 19 patches, have those been applied?

[Jay_Gregory]

To oracle?  Or to Pro?  I don't believe I have installed any Pro patches to address Oracle compatibility.  I am on Pro 2.9.3.  Where can I find more information about the patches?  I know the DBA said Oracle is patched with latest - they do not have any spatial libraries loaded on their DB though - I am just trying to access plain tables in a standard Oracle DB.  

[Jay_Gregory]

Absolutely uninteresting, but when I upgraded Pro to 3.0.1, my issue went away.