Re: DBLINK help,please!

the link does work!!
I can see all the objects..
more than this, I can call and execute all the "first level" procedures in the target database..
ma if they call other public procs accessing to DB tables, the just don't work
the user can see the link and has all the rights granted manually.

I'm a little sad...I read the "oracle 8i distribuited database system" from Oracle documentation and everything says it should be working..
thanks for help

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3CE27D15.8DD85B56_at_exesolutions.com>...
> curven wrote:
>
> > Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3CE1259E.587B8DE_at_exesolutions.com>...
> > > curven wrote:
> > >
> > > > Hi all,
> > > > please help me to solve my terrible trouble.
> > > >
> > > > I use
> > > > *ORACLE 8.1.6 on WNT
> > > > *TOAD 7.2
> > > >
> > > > I have to using dblink between 2 Databases
> > > > - the procA in DB1 calls procB in DB2
> > > > - procB call a public subprocedure (procC)
> > > > - if I call ProcA the code in procB is executed, the code in procC not.
> > > > - I can't see the output (through dbms_output)in DB2 from DB1
> > > >
> > > > I create the link this way:
> > > > create public database link PIPPO.DB2
> > > > connect to 'pippo' identified by <pwd> using 'dev00'
> > > >
> > > > - dev00 is DB2 service name
> > > > - I'm sure pippo has all the privileges in DB2
> > > > (I tryed to connect to SYS also...)
> > > > if I logon as pippo in DB2 everything works fine
> > > > - if procC gets access to tables, it doesn't work
> > > > if contains only simple logic (eg: a+b) everything works fine
> > > >
> > > > thank you ...
> > >
> > > Where did you see that a DB Link could be used to connect Oracle to DB2?
> >
> > I'm Sorry!!
> > I just mean "the first Database to the Second Database"
> > I don't know what is *DB2*
> >
> > >
> > > Daniel Morgan
>
> DB2 is the name of IBM's relational database product ... now renamed to UDB but everyone still calls it
> DB2.
>
> Have you tested the link to see if it work? Try:
>
> SELECT COUNT(*)
> FROM all_objects@<database_link_name>;
>
> If it doesn't work likely the problem is with the syntax you used to create the link. Verify it then if
> problems persist post it.
>
> If it does work then likely the problem is with permissions. Does the user trying to use the link have
> permissions to use it and can they see the objects? Is that permission granted directly or through a
> role?
>
> Daniel Morgan
Received on Thu May 16 2002 - 03:54:21 CDT