Re: How to access packages in remote database??

Hi
Try exec fnd_client_info.set_org_context_at_yasfnprd_apps(102)

Peter Rak
VSZ Kosice
Slovak Republic

Ng TC wrote:

> 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 Fri Jun 19 1998 - 00:00:00 CDT