PLS-00382

Hi all

here is a simple for loop in PL/SQL

FOR kategoria IN (SELECT KAT_ID FROM KATEGORIE) LOOP

        select * from artykuly where kat_kat_id = kategoria; END LOOP; when i try to compile, i get PLS-00382 : expression is of wrong type, pointing to kategoria (for variable) in the middle line. Anybody has an idea of what is wrong with this code, i just want to select all articles for all categories, maybe some other suggestions

any help is much appreciated
thx in advance Received on Tue Jun 17 2003 - 14:43:05 CDT