How to count ref cursor result set?
580861Aug 7 2007 — edited Aug 8 2007I have about 20 programs in a package. Each program returns ref cursor result set.
We are now want to create a process to count the output result set, if the output has more than 100 rows, we will raise an message.
I tried cursor%rowcount, but The %ROWCOUNT attribute returns the current row count of the cursor. After the cursor is opened, %ROWCOUNT is equal to zero.
Is there an general function to count total ?
Thank you