Re: Calling a remote function

Assuming you have a dblink set up between the local and remote databases... You can create a public or private synonym (depending on the needed scope) for the remote package on the local database and execute using the synonym.

For example, the following syntax:

  create public synonym REMOTE_PKG_SYN for OWNER.REMOTE_PKG_at_REMOTE_DB;

Would allow you to execute the following in SQL*Plus:

  execute REMOTE_PKG_SYN.FUNCTION(PARAMETERS...);

Hope this helps.

John Oldfield wrote:
>
> Hi,
> I am using Oracle 7.3 and I have a question that the Oracle team in my
> company couldn't help me:
> How can I execute a function that is defined in a package which is located
> on a remote database (we can assume there are no privilige problems)?
>
> Ronen Lewit
> email: lewit_at_zoot.tau.ac.il
 

-- 
         __________________________________________________         
        |                                                  |        
    _   |      Robert Fernandes - LLNL AIS Department      |   _    
   / )  |                                                  |  ( \   
 _( /_  |      Phone:       (925) 423-1397                 |  _) )_ 
(((\ \) |_     Fax:         (925) 423-5882                _| (/ /)))
(\\\\ \_/ )    LLNL Email:  rfernand_at_llnl.gov            ( \_/ ////)
 \       /                  fernandes6_at_llnl.gov           \        /
  \    _/                                                  \_     / 
  /   / |      Home Email:  rfernand_at_ainet.com             | \    \ 
 /   /  |__________________________________________________|  \    \