Public dblink with Scheduler issue.
577917Apr 18 2012 — edited Sep 26 2012We are using a current_user public db link to get data from another server. The procedures work fine when run from inside the schema, but we have them run as jobs in the Scheduler. As soon as we replaced the old private db link, which had uid/psw built in, with the public, which passes the credentials of the current user and doesn't have built in uid/psw , we stared getting the error:
ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from...
So basically everything works fine up to the point when we run the code from the Scheduler.
Can anybody explain this and offer a solution. Will be greatly appreciated.
George