What privileges are needed to create stored procedures and packages
To create package or a stored procedure in your own schema you will need:
CREATE PROCEDURE
privilege granted to your user account. To create packages and stored procedures in other
schemas you will need:
CREATE ANY PROCEDURE
This tip was posted as an answer to question: What do I need to be able to created packages and stored procedures in my own schema?