| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: level of calling procedures through DBLINK
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 Wed May 08 2002 - 15:21:10 CDT
 |
 |