Value error exception in plSQL

·

1 min read

DECLARE
 temp_number NUMBER;
 temp_string VARCHAR2(10) := 'BLAKE';
BEGIN
 temp_number := temp_string;
EXCEPTION
 WHEN VALUE_ERROR THEN
 DBMS_OUTPUT.PUT_LINE('A VALUE_ERROR occurred');
END;