What is the default size of a varchar2 input to Oracle stored procedure, and can it be changed?
You cannot specify a size for a VARCHAR2 parameter to a procedure.
The procedure should happily accept strings up to 32k in size (the maximum size of a VARCHAR2 in PL/SQL). If it were a function that was being called from SQL rather than PL/SQL, the limit would be 4k because the maximum size of a VARCHAR2 in SQL is only 4k.