Unanswered: Exception on remote oracle database when using a 'DBLink'
How do you view the exceptions that occur at target end of oracle 'dblink'?
I have multiple oracle processes(i.e. packages, procedures) that access tables on remote oracle databases via a 'dblink', and when an exception occurs on the remote database, where are the exceptions logged and how can I view the details?
When the exception is returned to machine that I'm running the package from I log into a applications log the details of what is returned.
For example this is an exception that occurs sometimes BUT not ALL the time
and if I run the code manually(in my SQL client) it works fine, so I need to see the details of what is happening on the remote database:
Failure in accts_unscored_pkg.credit_report procedure.
-12801: ORA-12801: error signaled in parallel query server P009
ORA-01008: not all variables bound
ORA-02063: preceding 2 lines from TO_ACCTS_DB
ORA-06512: at "ACCOUNTS.ACCTS_UNSCORED_PKG", line 831