Re: DBLINK help,please!

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
Received on Wed May 15 2002 - 04:01:41 CDT