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

In article <3j59ec$acv_at_ef2007.efhd.ford.com>, wmeahan_at_ef0424.efhd.ford.com (Bill Meahan) writes:
|> (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

In this case, the ny emp table would be updated. The procedure is executing in ny, so it would update the local table. Now if hire_emp_at_ny updated emp_at_boston, then it would be the other way around :) Received on Sat Mar 04 1995 - 00:02:18 CET