Hi All,
I was write a query to get all the ePerformance records' row count using only PSRECDEFN table.Here's my query and is ging me error as 'table or view doesnot exist'.

DECLARE
CURSOR c2 IS SELECT recname FROM psrecdefn WHERE objectownerid = 'HEP' AND RECTYPE NOT IN (1,2,3,4,5);
v_c1 c2%rowtype;
row_cnt NUMBER;

BEGIN
OPEN c2;
LOOP
FETCH c2
INTO v_c1;
EXIT
WHEN c2 % NOTFOUND;
EXECUTE IMMEDIATE 'SELECT COUNT(*) from PS_' ||v_c1.RECNAME|| 'INTO'|| row_cnt;
DBMS_OUTPUT.PUT_LINE('rows in table PS_' || v_c1.RECNAME || '=' || row_cnt);
--DBMS_OUTPUT.PUT_LINE('rows in table PS_' || v_c1.RECNAME);
END LOOP;
CLOSE c2;
END;

Please help me up to solve the query.Help appreciated if any one provide me the correct query