With an Access report that is coded to run a call to Toad for Oracle (connect to the Oracle database using ODBC driver and gather the requested info), when the report is run, Access returns the noted error:
"Run-time error '2147467259(800004005)' Oracle error occurred, but error message could not be retrieved from Oracle."
Toad does not support an ODBC connection.
WORKAROUND 1:
Create a script that uses a connection format Toad supports, i.e. TNS or LDAP using the Oracle native client.
WORKAROUND 2:
Create a script that accesses Toad for Data Analysts that does support ODBC connection and also Oracle.
*Note the features in Toad for Data Anaysts are more limited compared to Toad for Oracle. There might be some features in Toad for Oracle that may not exist in Toad for Data Analysts.
