Rookie Question

From: Ruediger Tams <ruediger.tams_at_komtel.net>
Date: Thu, 10 Jul 2003 15:40:00 +0200
Message-ID: <3F0D6CAF.9B59D538@komtel.net>

Hello,
possibly it is a very simple "rookie" question but: This statement don't work. why?

DECLARE
  CURSOR c1 IS
   SELECT a.tablename FROM info_tablerows a;    rows number;
BEGIN
  FOR r IN c1 LOOP
SELECT count(*) INTO rows FROM r.tablename;

UPDATE info_tablerows SET rowcount = rows WHERE tablename = r.tablename;
END LOOP;
END;
/

At "SELECT count(*) INTO rows FROM r.tablename;" the message "identifier r.tablename must be declared" appears. Isn't it possible to reference my tablename?

Thanks for hints.

regards ruediger Received on Thu Jul 10 2003 - 08:40:00 CDT