I changed the name to MyStoredProcedure for security reasons forgetting that I ahd already printed it in the PROD.

So that was an old ID-10-T erro on my part. 🙂

On your side of it, I am running TOAD 10.1.1.8 as my portal to Oracle. When I run your statment I get an Invalid SQL Statement error from TOAD. I even changed it to match my variable and that did not work:

variable Comnt_Detail refcursor;

exec PROD.GETWOTRV_CMNTS_ORL (166218, :Comnt_Detail);

print Comnt_Detail;

So if my issue is my Oracle PROD I can believe that, but I do not see where it is wrong.

Thanks for looking, any help you can provide would be a big help!

Ed