Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

connect problem with db link and scheduler_jobs on 10.2.0.4.0

394955Jan 19 2009 — edited Jan 20 2009
hello guys
i have got this problem, i hope someone can help me to understand and solve it.

I have a pl/sql procedure where is referenced a table on a db_link. I own all the grants needed, and if i recall it in an anonymous block, it seems to work.

i.e

create or replace procedure routine_1 is
v_app varchar2(1);
begin
select 'x'
into v_app
from other_user.some_table@my_db_link
where rownum<2;
end routine_1;




Instead, while recalling it from a job scheduled with dba_scheduler package, with the same user, while opening the cursor where the db link table is referenced, i got a connect error:

ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from xxxxxx (where xxxxxx is the db link)

i would like to understand where i am mistaking. I already checked the user for the connection in the scheduled job and is the same of the anonymous block call.

thanks in advance
Claudio
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2009
Added on Jan 19 2009
4 comments
1,420 views