the max length of the varchar2 parameter in oracle stored function

[rotem_fo]

Hi,
The maximum length of VARCHAR2 data is 4000 bytes when creating a table with VARCHAR2 columns,
but when using stored procedures/functions the maximum if VARCHAR2 data is 32767.


create table T1 (a varchar2(4001));
will succeed.
create table T1 (a varchar2(4001));
will fail.

declare
str varchar2(32767);
begin
null;
end;
/
will work

declare
str varchar2(32768);
begin
null;
end;
/
will fail

regards,
dbaora