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