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

In a previous posting, Bill Meahan (wmeahan_at_ef0424.efhd.ford.com) 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?

  Tables referenced by stored procedures are resolved at compile time, not at run time. Since hire_emp is compiled in the "ny" database the EMP table in New York would get updated.

--
   - Doug Harris
     Database Administrator, System Development Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##