this is the real problem:
* if I login as B, it works as well (even if B user is Sys and it has
all the right)
* using the dblink, the submodules with tables handling (insert,
select etc..) don't work, the others with only logic inside do work...
Frank <fbortel_at_home.nl> wrote in message news:<3CD988B6.5060102_at_home.nl>...
> curven wrote:
>
> > I'm soory, mate.
> > * the ORACLE version is: 8.1.2
> > * I'm currently using TOAD v7.2
> > * error code is
> > ORA-04062: timestamp of package "A" has been changed@@
> >
> > the problem is : the debug is very difficult because I cannot see
> > output from procedure1 in B.
> > if I use dbms_output.put() it doesn't write in the output window.
> >
> > PS I granted execute to all user from A
> >
> How? Via a role will not work. You must grant to the user directly.
>
> Also - how is the db link set up? There must be a user on B, that the
> db link from A connects to - that user will execute the proc, and should
> have rights. You can debug by logging on as that user on B, and see
> if it works then.
> And procedure1 can only be executed if declared public (in the package
> specification).
>
> Hth, Frank
Received on Fri May 10 2002 - 08:58:12 CDT
