SQL & PL/SQL

Hi,

I'm having one pl-sql package.

I'm trying to compile it due to code change.

But when I'm trying to compile it i'm getting DB link error which does not exist in the current database.

I don't want to use DB link in the current database. so I'll comment out the DB link code.

But here is i'm having problem that package is using number of package procedures which in turn use DBlink and i'm not able to find out those package procedures which uses DB link.

Even complier is also not showing me those code/packages where this error os occuring.

Please tell me is there is any way to find out the code which used DB link.

Thanks in Advance,
Arun


Adding Details as per suggersion:

Oracle Version:

Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

Error:

XXXX@XXX.XXX ORA-00604: error occurred at recursive SQL level 3 ORA-12154: TNS:could not resolve service name.

Edited by: Pratiarun on Jan 4, 2010 12:59 PM