Gurus,
Need to use an inline select to compare against a literal number. I thought I could use a "while" loop for this but get errors. Any alternate suggestions out there?
while (select count(1) from mtl_cycle_count_entries where cycle_count_header_id = crec_purge_cc_by_hdr.cycle_count_header_id) > 0
loop
...
end loop;
Thanks.
Points for helpful or correct answers.