在plsql的test窗口用for循环

declare in_productnum varchar2(50);in_username varchar2(50);in_realname varchar2(50);begin  FOR dtl IN  (select t.product_num from scm_mtl_catalog_tbl t2left join (SELECT a.*,a.rowid,                     RANK() OVER(PARTITION BY a.PRODUCT_NUM ORDER BY a.INSERT_DATETIME desc) RK                FROM scm_ws_sc_catalog_change_tbl a               where 1=1                 --and a.INSERT_USER_NAME = 'SCM'                 ) t                 on t.Rk = 1  and t.product_num = t2.mtl_cat_codewhere   1=1  and (DECODE( trim(t.valid_flag),'X','N','','Y') != t2.enabled_flag)and t.insert_user_name = 'PAG_MTL_CATAlOG.import_sc_catalog') LOOPin_productnum :=dtl.product_num;in_username :='wangjing32';in_realname :='王静';  -- Call the procedure  pag_mtl_catalog.enablecat(in_productnum ,                            in_username,                            in_realname );                            end Loop;end;