ORA-06502: PL/SQL Numeric or Value Error

What Does This Error Mean?
This error indicates a numeric or string conversion issue, typically when assigning a value to a variable with incompatible size or datatype.
Common Causes
• String value exceeds declared VARCHAR2 size.
• Invalid numeric conversion.
• Division by zero error.
How to Fix
Example:
DECLARE
v_name VARCHAR2(5);
BEGIN
v_name := 'Jonathan';
END;
Error occurs because the string is too long.
Fix: Increase size
DECLARE
v_name VARCHAR2(20);
Prevention Tips
• Use appropriate data sizes.
• Apply exception handling.
• Validate input before assignments.