DBLINK help,please!

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 ... Received on Tue May 14 2002 - 06:27:04 CDT