How to access packages in remote database??

From: Ng TC <tcng_at_yas.com.sg>
Date: 1998/06/18
Message-ID: <6m9vqb$n6b$1@newton2.pacific.net.sg>#1/1

Hi,

I have an in-house application database (k200), and an Oracle Financials database (yasfnprd).

There is a database link from k200 to yasfnprd called 'yasfnprd_apps'.

From k200, I want to access a package (fnd_client_info.set_org_context(102)) in yasfnprd. I tried:

SQL> execute fnd_client_info_at_yasfn107_apps.set_org_context(102); begin fnd_client_info_at_yasfn107_apps.set_org_context(102); end;

*

ERROR at line 1:
ORA-04054: database link YASFN107_APPS.SET_ORG_CONTEXT does not exist

I also tried:

SQL> execute fnd_client_info.set_org_context(102)@yasfn107_apps; begin fnd_client_info.set_org_context(102)@yasfn107_apps; end;

*

ERROR at line 1:
ORA-06550: line 1, column 43:
PLS-00103: Encountered the symbol "@" when expecting one of the following: := . ( % ;
Replacing "@" with ":=".

What should I do???

Please help!!

Regards,
Tse Chong
email: tcng_at_yas.com.sg <- please reply to email Received on Thu Jun 18 1998 - 00:00:00 CDT