REPRODUCIBLE:
In the "runner..." panel, the generated code (below sample), the parameters are shown with a pencil icon.
Click the pencil icon, type or paste in the parameter value and click [Save]. The provided values are included as local variables as shown. Click [Run] or [Debug] as the case may be.
SCRIPT_OUTPUT
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: value or conversion error: character string buffer too small
ORA-06512: at line 5
https://docs.oracle.com/error-help/db/ora-06502/
More Details :
https://docs.oracle.com/error-help/db/ora-06502/
https://docs.oracle.com/error-help/db/ora-06512/
ROOT CAUSE IS: The DEFAULT generated code is too small VARCHAR2(200).
The size should either default to perhaps 4000, OR be dynamic using length( ParameterValue ).
[View PL/SQL]
-- runner for NEO.P_BANNER
SET SERVEROUTPUT ON
DECLARE
V_MESSAGE_IN VARCHAR2(200);
H_CHAR_IN CHAR;
BEGIN
V_MESSAGE_IN := 'In debug "runner..." panel, the parameters are shown with a pencil icon.
When pencil is clicked the large panel opens. I type or paste in the parameter value and click [Save]
BECAUSE default generated code is too small VARCHAR2(200) How about making the default 4000 or dynamic length( ParameterValue) ?';
H_CHAR_IN := '*';
NEO.P_BANNER(
V_MESSAGE_IN => V_MESSAGE_IN,
H_CHAR_IN => H_CHAR_IN);
-- Rollback;
end;