DBMS_JOB and distributed database problem

[Quoted] We have prepare store procedure that insert data in table from remote database . For remote database we have create public database link. When we running this store procedure by itself it works properly.But when we submit this store procedure by DBMS_JOB package for periodical running the follows error raised :
ORA-01005: null password given; logon denied ORA-02063: preceding line from NOCDB (NOCDB remote database name)

The same store procedure to the same(no-distributed) database works with DBMS_JOB properly.
Can anyone advise what is the problem .

Thanks , Hanan Brener

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 03 2000 - 00:00:00 CEST