How to Resolve PLS-00123: program too largeby Ed ChenJune 26, 2021August 17, 2021PLS-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 Resolve ORA-01031: Insufficient Privilegesby Ed ChenJune 24, 2020June 18, 20221 CommentORA-01031 ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error can be… Read More »How to Resolve ORA-01031: Insufficient Privileges
How to Backup PL/SQL Codes in Oracleby Ed ChenSeptember 11, 2019August 27, 2021Backup 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