Oracle Stored Procedure to use another Schema's views : <p>I'm writing a Stored Procedure to automate a task, and in one of the steps I need to Select data from a view that's in another user's schema.</p>

<p>I can query the data from that View outside the Stored Procedure but apparently not in a SP under my schema. </p>

<p>Is this by design or am I missing something? Are there any workarounds?</p>

<p>Thanks</p>
