How to setup a new schema user in APEX inside of Oracle Cloud Infrastructure with grant to UTL_HTTP
I just provisioned an APEX instance on OCI and setup a new workspace and schema user but am not able to access any of the base functions such as the UTL_HTTP package. For example, if I go to the SQL Commands in the SQL Workshop and try to run this "select utl_http.request('http://www.GOOGLE.com') from dual;" I get this error: "ORA-01031: insufficient privileges". I get the same error if I try and run the grant execute command to the schema user as well. This is preventing me from creating objects and accessing some standard functionality like creating REST Data Sources. Any help would be greatly appreciated!