I opened a cursor and trying to step through it. The problem I came
across is how to check whether the end of the cursor have been reached,
smth like "if (rec%NOTFOUND)" in Oracle. Any ideas how to do this
gracefully without running an sql query to find out the size of the
cursor record set?
BTW, is there any other way to step through records returned by a
dynamic query. For example, suppose I have a query "select col_name from
table_name", where col_name and table_name are passed as a parameter to
a procedure. I want to step through the result of this query and put all
values in the column in a coma-separated array.
Thanks.
Oleg