how to select multiple rows using execute immediate
442326Apr 25 2005 — edited Apr 26 2005I have a function which accepts multiple args and uses them to build a select statement and I then run this via execute immediate. All works fine when only one row is returned, but I get no output when the select statement would return multiple rows. How do I handle this OR should I build my sql statement and run it some other way?