Hello everyone,
I am reaching out as I am getting an ORA-12545 error, on occasion, when I run a job that contains a chain.
The chain contains procedures that reference a DB link. To my understanding, it appears that might be the issue - connectivity to the db link that, at points, is lost but would much appreciate any guidance/direction that could be taken.
On a unrelated note, I wanted to ask what's everyone's experience has been like with chains and whether that is a good/most efficient tool to utilize for my use case:
- Load data into staging.
- Only once successfully confirmed, merge into the main table.
Seems to be working well, but of course having the problem above.
Thanks,
Jay