pl/slq: how to use variable as from in select

hello

in pl/sql i wrote the following statement :   LOOP

      FETCH c_AnzBelege INTO c_TName;
      EXIT WHEN c_AnzBelege%NOTFOUND;
      


        SELECT Name,Login
	FROM c_TName 
	WHERE trunc(create_on) = trunc(sysdate)-1;

  END LOOP But i got PLS-00201 at the FROM variable? Could someone explain how to do it right?

thx a lot
ralf

-- 
_____________________________________________________________
NewsGroups Suchen, lesen, schreiben mit http://netnews.web.de