GRANT EXECUTE on SYS Package to PUBLIC
We used the following SQL statement to retrieve and compose necessary GRANT statements for you to fix your compiler problems related to SYS's public packages,… Read More »GRANT EXECUTE on SYS Package to PUBLIC
GRANT EXECUTE ON
SYS Packages Granted to Public
For your reference, here I list packages owned by SYS, which should be granted with EXECUTE privilege to PUBLIC in 19c. Theoretically, there's no need… Read More »SYS Packages Granted to Public
How to Resolve PLS-00201: identifier 'DBMS_SQL' must be declared
PLS-00201 We have talked about some common patterns of PLS-00201. Here is another case. Found some packages of CTXSYS are invalid, most compile errors are… Read More »How to Resolve PLS-00201: identifier 'DBMS_SQL' must be declared