subprogram or cursor reference is out of scope

[sonofsita]

be sure that the owner of the proc and the refered to objects are one and the same. else there should be grants to the owner of the proc. try this.