No of Rows for DBMS_SQL.EXECUTE
Need to get the TOTAL count of no of rows that is retreived from SELECT statement for DBMS_SQL.EXECUTE. Is there any subprogram in DBMS_SQL.EXECUTE which gets me the no of rows retreived from a SELECT STATEMENT in DBMS_SQL.EXECUTE.
It should function the way SQL%ROWCOUNT functions.
Things which dont satisfies the above requirement in DBMS_SQL is as follows:
DBMS_SQL.EXECUTE_AND_FETCH
DBMS_SQL.FETCH_ROWS
DBMS_SQL.LAST_ROW_COUNT
Could any one put some thought into it. :)