SQL & PL/SQL

Hi ,

I have a dynamic sql with runtime number of columns in SELECT clause

eg. SELECT || col_list ...FROM ..

Now when i execute this i dont get the correct SQL%ROWCOUNT ....Since the column list is undecided, cant create a cursor variable to FETCH the values and capture %FOUND...

Any help ..???

PS:  The above query will return a single row only (SINGLE SELECT) , as this might be helpful