Link to home
Start Free TrialLog in
Avatar of feign3
feign3

asked on

Defaulting a null value in owa_util.ident_arr

Does anyone know how to default a null or empty value to owa_util.ident_arr? I've tried "owa_util.ident_arr DEFAULT NULL" and "owa_util.ident_arr DEFAULT EMPTY" but neither will compile.

Any ideas?
Avatar of Danielzt
Danielzt


   ident_arr is a type in OWA package.
   ...
   type ident_arr is table of varchar2(30) index by binary_integer;
   ...

   you just define a variable of type ident_arr. it will be null before you assign it.

   variable_name ident_arr;

     I do not think you need to default a null to a TYPE.
Avatar of feign3

ASKER

Sorry, I didn't specify... I want to default it to null as an IN variable:

CREATE OR REPLACE PROCEDURE ew_open_order_csv(selected_category in owa_util.ident_arr default empty,category_v in util.ident_arr default empty,org_v in number default null,subinv_v in varchar2 default null,cat_count_v in number default null)AS
Avatar of feign3

ASKER

Hold on... I think your right.
ASKER CERTIFIED SOLUTION
Avatar of thrasher_hu
thrasher_hu

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial