CREATE OR REPLACE FUNCTION ac_data (p_id IN VARCHAR)
RETURN tab_state
PIPELINED
AS
ac_data tab_state;
out_data tab_state;
CURSOR ac\_c
IS
SELECT \*
FROM EMPLOYEE\_DETAILS
WHERE ID = p\_id
BEGIN
FOR ac_data IN ac_c
LOOP
PIPE ROW ( (ac_data));
END LOOP;
END ac_data ;
Here how will store the pipe row data to another variable?. I need count of ac_data.