If I define the cursor that accepts 2 parameters like this:
CURSOR cur_det (var1 IN varchar2,var2 IN varchar2) IS
Is it poss开发者_运维问答ible to specify their size? thanks
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.
精彩评论