sqloracle-databaseplsqlcursor

Specifying variable size when passing one to the cursor in Oracle

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?

Solution

  • 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.