josephcurven_at_katamail.com (curven) wrote in message news:<eae12a5f.0205150101.67a08747_at_posting.google.com>...
> 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
Was your link created successfully or not?
Michael Tubuo Ngong(Sr DBA)
Received on Wed May 15 2002 - 10:10:59 CDT
