Greetings,
I am on autonomous database on my oracle always free cloud account. Workload type = APEX. I need to use a reporting tool called Jasper reports integration. This tool needs the database user that will call reports to be able to make use of UTL_HTTP package. So, I tried to grant execute on utl_http to my parsing schema(the schema that will call the reports). I did that through my “admin” user on the autonomous database. The grant was made successfully. But when tried to use UTL_HTTP through my parsing schema that was granted the permission, it showed “insufficient privileges” error.
Some says that, UTL_HTTP is not allowed for autonomous database on OCI with workload type APEX. But I can see the error “Insufficient Privileges” implies something else.
So, is there a problem with granting the privilege or is it not allowed to use that package in my case?