Simple add lines as shown:
> for r in select * from tconcattest loop IF r.str IS NOT NULL THEN> output := output || r.str; END IF;> end loop;
- Andrew