Hi
Can i query the table object by passing a parameter like this. I get error invalid date type. How to do this please. Letters in bold get the error.
declare
cursor emp_cv is select building,category,amount from fa_locations fl ,fa_categories fc
where fl.location_id=fc.location_id;
TYPE l_building_tbl_type IS TABLE OF fa_locations.segment5%TYPE;
l_building_tbl l_building_tbl_type;
begin
FETCH emp_cv bulk collect into l_building_tbl
,l_category_tbl
,l_amt_tbl;
*select count(*) from table(cast(l_building_tbl as l_building_tbl_type))*
*where l_building_tbl='MFG';*
end;