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
Procedure
How to Resolve ORA-01031: Insufficient Privileges
ORA-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 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