Remote package access

From: KelisaLee <jiayng_at_yahoo.com>
Date: 16 Dec 2004 19:30:35 -0800
Message-ID: <8ce04043.0412161930.3e365a94@posting.google.com>

Hi,

I'm writting a package in database on one machine, which will remote access to a package in database running on another machine. When i run the script to create the package, I get following error:

ERROR at line 2:
ORA-04052: error occurred when looking up remote object MCD.P_MCD_LOAD_at_MCD.MKZ.INFINEON.COM
ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 27192 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values") ORA-02063: preceding line from MCD.MKZ.INFINEON.COM

Things been checked.

1. Remote package is working fine.
2. DBlink (MCD.MKZ.INFINEON.COM) is already existed.
3. TNS name is already existed and correct.

Is the error caused by the database shared memory size? Do you have any idea what is wrong? Any suggestion? Thanks.

Regards,
Jia Yng Received on Thu Dec 16 2004 - 21:30:35 CST