Re: DBLINK help,please!

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?

Daniel Morgan Received on Tue May 14 2002 - 09:56:32 CDT