PL/SQL, WebDB owa.vc_arr

[fatcodeguy]

WebDB forms and reports use the owa.vc_arr data type to pass arguments to procedures. It's a special array but I don't know how to extract the data from it (not as per conventional array).

Can anyone help me ? Thanks

 

[BFritz]

An example :

function RET_FLD (ifld in varchar2
,num_entries in out number
,name_array in out owa.vc_arr
,value_array in out owa.vc_arr
,reserved in out owa.vc_arr
) return varchar2 is
wix number;
wval varchar2(300);

begin
for wix in 1..num_entries loop
if name_array(wix) = ifld then
wval := value_array(wix);
end if;
end loop;
return wval;
end;

Bye