Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Is there any limit on how many records a cursor can hold?

797402Nov 8 2010 — edited Nov 8 2010

Hi Everyone,

This is Amit here. I want to know whether there is any limit on how many records a cursor can hold.

I have a program in which i am creating a cursor and passing it to another procedure as an input parameter. But the count of cursor query is more than 15 Lakhs. The program is running forever.

Just wanted to know whether the huge data is the problem.

Thanks ....

Regards,
Amit

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2010

Added on Nov 8 2010

#general-database-discussions

4 comments

6,193 views