Articles to Write

6. Exception Handling

• Predefined Oracle Exceptions
• User-Defined Exceptions
• Exception Propagation
• RAISE_APPLICATION_ERROR

7. Procedures and Functions

• Creating Stored Procedures
• Creating Functions
• IN, OUT, and INOUT Parameters
• Overloading Procedures and Functions

8. Packages

• Creating and Using Packages
• Package Specification
• Package Body
• Private vs Public Package Components
• Forward Declarations

9. Triggers

• Types of Triggers (Row-Level, Statement-Level)
• BEFORE and AFTER Triggers
• INSTEAD OF Triggers
• System Triggers
• Compound Triggers

10. PL/SQL Collections

• PL/SQL Tables (Associative Arrays)
• Nested Tables
• VARRAYs
• Collection Methods (COUNT, EXTEND, DELETE, TRIM, EXISTS, FIRST, LAST)

11. Dynamic SQL

• EXECUTE IMMEDIATE
• DBMS_SQL Package
• Binding Variables in Dynamic SQL

12. Transactions in PL/SQL

• COMMIT, ROLLBACK, SAVEPOINT
• Autonomous Transactions
• Locking Mechanisms

13. Bulk Processing in PL/SQL

• BULK COLLECT
• FORALL Statement
• Performance Benefits of Bulk Processing

14. Working with XML and JSON in PL/SQL

• Using DBMS_XMLGEN and DBMS_XSLPROCESSOR
• Working with JSON (JSON_OBJECT, JSON_QUERY)

15. Advanced PL/SQL Concepts

• PL/SQL Compiler and Optimization (Pipelined Table Functions)
• Dependency Management
• Secure Coding Practices in PL/SQL

2. SQL Execution and Query Errors

11. ORA-00979: Not a GROUP BY expression
12. ORA-01000: Maximum open cursors exceeded
13. ORA-01403: No data found
14. ORA-01422: Exact fetch returns more than requested number of rows
15. ORA-01438: Value larger than specified precision allowed for this column
16. ORA-01722: Invalid number

3. Constraint and Integrity Errors

21. ORA-00001: Unique constraint violated
22. ORA-02290: Check constraint violated
23. ORA-02291: Integrity constraint (foreign key) violated – parent key not found
24. ORA-02292: Integrity constraint violated – child record found
25. ORA-04098: Trigger <trigger_name> is invalid and failed re-validation

4. Cursor and Transaction Errors

26. ORA-01001: Invalid cursor
27. ORA-06511: PL/SQL: Cursor already open
28. ORA-06512: At line <number> (backtrace error)
29. ORA-06519: Active autonomous transaction detected
30. ORA-06550: Line <number>, Column <number>: Compilation unit errors

5. Locking and Concurrency Errors

31. ORA-00054: Resource busy and acquire with NOWAIT specified
32. ORA-00060: Deadlock detected while waiting for resource
33. ORA-01555: Snapshot too old – rollback segment too small
34. ORA-02049: Timeout: Distributed transaction waiting for lock

6. Storage and Memory Errors

35. ORA-01652: Unable to extend temp segment by <number> in tablespace <tablespace_name>
36. ORA-04030: Out of process memory when trying to allocate <bytes>

7. PL/SQL Runtime Errors

37. ORA-06502: PL/SQL: Numeric or value error
38. ORA-06503: PL/SQL: Function returned without value
39. ORA-06504: PL/SQL: Return types of Result Set variables do not match
40. ORA-06508: PL/SQL: Could not find program unit being called

8. Large Object (LOB) and File Handling Errors

41. ORA-22275: Invalid LOB locator specified
42. ORA-22285: Non-existent directory or file for BFILE operation
43. ORA-22288: File or LOB operation failed

9. Network and Connectivity Issues

44. ORA-03113: End-of-file on communication channel
45. ORA-03135: Connection lost contact
46. ORA-12537: TNS: Connection closed

10. Miscellaneous PL/SQL Errors

47. PLS-00225: Subprogram or cursor ‘NAME’ reference is ambiguous
48. PLS-00597: Expression ‘X’ in the INTO list is of wrong type
49. PLS-00642: Local collection types not allowed in SQL statements
50. PLS-00707: Unsupported construct or feature encountered