Alex Rivera | Logout

What is the size limit for a varchar2 PL/SQL subprogram argument in Oracle?

Asked 2008-10-09T08:26:10.113
14

When you create a procedure (or a function) in Oracle PL/SQL, you cannot specify the maximum length of the varchar2 arguments, only the datatype. For example

create or replace procedure testproc(arg1 in varchar2) is
begin
  null;
end;

Do you know the maximum length of a string that you can pass as the arg1 argument to this procedure in Oracle ?

Edit
Report

1 Answer

16

In PL/SQL procedure it may be up to 32KB

Futher information here: http://it.toolbox.com/blogs/oracle-guide/learn-oracle-sql-and-plsql-datatypes-strings-10804

answered 2008-10-09T08:35:34.227

Your Answer