I have a proc that receives as parameter a varchar2 type.
Currently when complying for PROC, the standard size of this varchar2 is 200.
I need to pass a string with a size than 1000
If there is any variable of Oracle environment, or any suggestion of how to increase this standard size at the time of compilation?
Example:
create or replace
PROCEDURE proc
(
variavel VARCHAR2 --> não consigo passar tam > 200
)
IS
vQtdeStop NUMBER;
BEGIN
vQtdeStop :=1;
END proc;
ORA-06502: PL/SQL: erro: character string buffer too small numérico ou de valor
ORA-06512: em line 8