search

PhilippSalvisberg / plscope-utils

Utilities for PL/Scope in Oracle Database
Apache License 2.0
35 stars 17 forks source link

No access to UTL_XML / UTL_XML_LIB in ATP #30

Closed PhilippSalvisberg closed 4 years ago

PhilippSalvisberg commented 5 years ago

Failure when installing plscope-utils in the OracleCloud. parse_util package body is invalid due to missing grant.

PhilippSalvisberg commented 4 years ago

The ADMIN user is not a full DBA. Not all objects owned by SYS are accessible.

I have tried to use DBMS_METADATA.PARSE_QUERY. But the use is restricted. Without a valid handle the output is always NULL.

The only option I see is to check if UTL_XML and UTL_XML_LIB are accessible. And if not, then a reduced set of objects are installed.