Originally Posted by
gandolf989
I wonder if this related to Oracle security.
You might need to manually grant apps access to the package if you specify the schema owner, even if that is you. But because users can't grant themselves anything have sys do an explicit execute grant on this package to apps and try the original test again.
As SYS user, I did grant EXECUTE on apps.samir_test to APPS and then executed original pl/sql block using apps. and still getting the same error.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
Reply With Quote