SQL>
SQL> CREATE OR REPLACE PROCEDURE ParameterLength (
2 p_Parameter1 IN OUT VARCHAR2,
3 p_Parameter2 IN OUT NUMBER) AS
4 BEGIN
5 p_Parameter1 := 'abcdefghijklmno';
6 p_Parameter2 := 12.3;
7 END ParameterLength;
8 /
Procedure created.
SQL>
SQL> DECLARE
2 v_Variable1 VARCHAR2(10);
3 v_Variable2 NUMBER(7,3);
4 BEGIN
5 ParameterLength(v_Variable1, v_Variable2);
6 END;
7 /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "RNTSOFT.PARAMETERLENGTH", line 5
ORA-06512: at line 5
SQL>