Home » SQL & PL/SQL » SQL & PL/SQL » Bulk collect
icon14.gif  Bulk collect [message #292760] Wed, 09 January 2008 15:56 Go to next message
Messages: 1
Registered: January 2008
Location: California
Junior Member
Anyone can help me with bulk collects and bulk binds in cursors. I am new to it. I am trying to fetch 2 records at a time

Suppose i say
not_used emp%rowtype;
oldest_rec emp%rowtype;
latest_rec emp%rowtype;
Open e_cur
fetch e_cur into oldest_rec;
fetch e_cur into latest_rec;
Open e_rec(oldest_rec.e_no);
fetch e_rec into not_used;
close e_rec;
close e_cur;

How can I use bulk collect here
Re: Bulk collect [message #292764 is a reply to message #292760] Wed, 09 January 2008 16:04 Go to previous messageGo to next message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you really want an answer you should post a precise question.
First thing, post a code that can compile.
Then, explain with words your code and what you expect.

Also please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Always post your Oracle version (4 decimals).


[Updated on: Thu, 10 January 2008 00:56]

Report message to a moderator

Re: Bulk collect [message #292783 is a reply to message #292764] Wed, 09 January 2008 20:11 Go to previous message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
The manual should be able to help


Ross Leishman
Previous Topic: ORA-01403: no data found
Next Topic: Simultaneous UPDATE/SELECT, is this possible
Goto Forum:

Current Time: Sun Aug 20 14:23:08 CDT 2017

Total time taken to generate the page: 0.02560 seconds