How to access packages in remote database??

Hi,

[Quoted] 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)_at_yasfn107_apps; begin fnd_client_info.set_org_context(102)_at_yasfn107_apps; end;

*

ERROR at line 1:
ORA-06550: line 1, column 43:
PLS-00103: Encountered the symbol "_at_" when expecting one of the following: := . ( % ;
Replacing "_at_" 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 CEST