If I define the cursor that accepts 2 parameters like this:
CURSOR cur_det (var1 IN varchar2,var2 IN varchar2) IS
Is it possible to specify their size?
No, you cannot specify varchar2(100)
or something similar. The varchar being passed is not constrained.
You can use the %Type to anchor the parameter to a database column, i.e., my_table.a_column%Type
. But I don't think that actually constrains the parameter.