Stored Proc reference table outside schema

[lesstjm]

What you needed to do was have the oracle owner grant you rights to select on his table.

grant select on product to lew;
You procedure would then work fine..