SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get count In Cursor

716369Sep 21 2009 — edited Sep 22 2009

Hi Guys
I have Cursor now i want to check weather its return any row before i fetch it and do some processing.what i have done is i have open cursor and then check for %rowcount > 0 but it doesnt work.

Please guide me

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2009

Added on Sep 21 2009

#cursor

6 comments

1,163 views