table name as variable in loop
the_slkSep 16 2009 — edited Nov 27 2010Hallo
I'm trying to use code like:
DECLARE
CURSOR cv_table IS SELECT table_name FROM user_tables WHERE table_name LIKE 'TEST%';
v_table_name CHAR(16);
BEGIN
OPEN cv_table;
LOOP
EXIT WHEN cv_table%NOTFOUND;
FETCH cv_table INTO v_table_name;
select * from v_table_name where rownum<2;
END LOOP;
END proc_cs_fast_stats;
Error report:
PL/SQL: SQL Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
any ideas? thanks a lot for answer.