Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
TRUSTED BY
For stored procedures the permissions need to be granted to the user that owns the procedure directly and not through a role.
Also: You really shouldn't be creating tables and performing grants inside a stored procedure like that. Oracle normally doesn't need to do that.