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
Package
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 Install USER_LOCK Package
USER_LOCK USER_LOCK is not a default package of SYS, you need to install it before using it. SQL> conn / as sysdba Connected. SQL> @?/rdbms/admin/userlock.sql… Read More »How to Install USER_LOCK Package
How to Resolve PLS-00123: program too large
PLS-00123 When we compile a big program unit, we may get PLS-00123 if it exceeds any one of compiler limitations that Oracle allows. ... declare… Read More »How to Resolve PLS-00123: program too large
How to Backup PL/SQL Codes in Oracle
Backup Packages and Procedures Usually, source codes of programming unit should be version-controlled by the developer team. Mostly, they use Git, CVS or SVN to… Read More »How to Backup PL/SQL Codes in Oracle