Understanding How to Handle ORA-00955 Error When Creating or Truncating Tables in PL/SQL

Outputting num_array Procedure Results in Oracle PL/SQL: A Comprehensive Guide

Understanding PLS-00103 Error: A Deep Dive into PL/SQL Syntax and Variable Usage

Resolving ORA-06502 Errors in Oracle PL/SQL: Variable Declarations and String Manipulation

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

Calculating Output from String Arithmetic Expressions using SQL and XQuery

How to Automatically Generate Insert Queries with PL/SQL for Large Datasets

Understanding and Correcting Common Oracle SQL Error Handling Mistakes

Understanding Oracle's Unique Constraint Error ORA-00001: A Deep Dive into Resolving Duplicates with IGNORE_ROW_ON_DUPKEY_INDEX Hint

Accessing Data from Row Type Variables in Oracle PL/SQL: A Deep Dive