I can help with some of the issues you're facing.

How to Use LOG ERRORS Feature in Oracle Databases for Row-Level Failure Information

Removing Duplicates from json_array_t in C++

Checking if Column Exists in Table and Using it in WHERE Clause with T-SQL, PL/SQL, and SQL Macro.

Using Intermediate Tables to Create Final Tables with Results: Alternatives to the Current Approach

Understanding Output Control Structures in PL/SQL: Best Practices for Writing Robust Code

Optimizing PL/SQL Code with the plsql_optimize_level Parameter: Best Practices for Coverage Collection

5 Ways to Reuse SQL Queries in Procedures Without Code Duplication

Understanding Oracle SQL, Date and Time in GMT (UTC)

Preventing Data Insertion with Oracle Triggers: A Practical Guide to Enforcing Business Rules.