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
>
> thank you all
> bye
>
> Frank <fbortel_at_home.nl> wrote in message news:<3CD83E64.5080208_at_home.nl>...
> > curven wrote:
> >
> > > Hi all,
> > >
> > > I have the database A holding access to database B through a public dblink,
> > >
> > > I cannot use "underlevel" procedure inside B through the db link:
> > >
> > > * I call from A: test_at_B
> > > * test call procedure1 inside
> > >
> > > cannot execute procedure1.
> > >
> > > thanx..
> > >
> >
> > Read the "FAQ Etiquette and how to get an answer"
> > Version, environment, error code(s)?
I presume you mean 8.1.7.2. (there is no 8.1.2).
DBMS_OUTPUT will only write to the SQL*Plus window if you type SET SERVEROUTPUT ON and hit the enter key before running the procedure.
Daniel Morgan Received on Wed May 08 2002 - 10:02:00 CDT