ORA-06502: PL/SQL: numeric or value error: character string buffer too small: A Guide to Resolving the Issue with Large Values in Oracle Databases

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

Resolving ID Value Issues in Oracle PL/SQL: A Trigger Solution

How to Establish One-to-Many Relationships and Filter Records from a Car Table Based on Specific Driver Groups in Database Queries

Capturing User Information with Oracle Triggers: Best Practices and Solutions

Using Oracle Triggers to Populate a Table: A Deep Dive into Troubleshooting Failed User Logons

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

Calculating Aggregate Affected Rows with Multiple DML Queries in PL/SQL: A Comprehensive Approach

How to Create a Parameterized Function with System Date Default in Oracle: Best Practices and Tips

ORA-04073: Column List Not Valid for This Trigger Type When Using BEFORE INSERT Triggers Without FOR EACH ROW Clause