Raise the VALUE_ERROR exception : Variable Declare « PL SQL « Oracle PL / SQL






Raise the VALUE_ERROR exception

 
SQL>
SQL> DECLARE
  2    v_TempVar VARCHAR2(3);
  3  BEGIN
  4    v_TempVar := 'ABCD';
  5  END;
  6  /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 4


SQL>
SQL>
SQL>

 








Related examples in the same category

1.Declare variable as a loop counter
2.Variables and Constants
3.Defining the Indefinable: NULL
4.Raise the 'no data found' exception
5.Declare variables which will be used in SQL statements