-
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.
Regards,
Surajit K Mitra
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|