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:

Could any one put some thought into it.