Re: DBMS_JOB and distributed database problem

You probably created a database link without an username and password. You need to do either
a) make sure the username and password are identical in both databases b) create a separate link with username and password

Hth,

Sybrand Bakker, Oracle DBA

<hananb_at_xosoft.com> wrote in message news:8mbucv$p88$1_at_nnrp1.deja.com...
> 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