PL/SQL RPC's - Where are they executed?

(Using the [in]famous emp table example ....)

Suppose I have two sites, New York and Boston connected by a network with links 'bos' in the New York database linking to Boston and 'ny' in the Boston database linking to New York. Each has an EMP table. On the New York site, there is a stored procedure named 'hire_emp' which takes some parameters and modifies the EMP table (unqualified).

I have an application running on the Boston machine that executes:

      hire_emp_at_ny(param1, param2, ...);

Which EMP table gets updated?

Oracle's documentation is, shall we say, less than clear on this point :-(

--
Bill Meahan,  Senior Developer  |        wmeahan_at_ef0424.efhd.ford.com
Electrical & Fuel Handling Division, Ford Motor Company
Opions expressed herein are those of the author and in no way represent
any official statement or opinion of Ford Motor Company