ORA-06502: PL/SQL: numeric or value error: character string buffer too small when adding Hebrew parameter in debugger
When trying to add a Hebrew parameter when debugging a procedure, the following error appears when pressing F7:
10:20:32 ORA-06550: line 6, column 6:
10:20:32 PLS-00103: Encountered the symbol "IN_PARAMETER_ENG" when expecting one of the following:
10:20:32 := . ( @ % ;
10:20:32 The symbol "(" was substituted for "IN_PARAMETER_ENG" to continue.
13:52:59 ORA-06502: PL/SQL: numeric or value error: character string buffer too small
13:52:59 ORA-06512: at line
Issue occurs if Oracle 10.1 client is in use
Please install at least a 10.2 Oracle client, and this will resolve the issue.