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
dev1
Messages: 1
Registered: January 2008
Location: California
Junior Member
Hi
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;
begin
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;
end;

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: 64103
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).

Regards
Michel

[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
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
The manual should be able to help

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/tuning.htm#sthref2231

Ross Leishman
Previous Topic: How to do insert an xml with a XML reserved character
Next Topic: Select - how to get the value of the last row for each key
Goto Forum:
  


Current Time: Sun Dec 04 10:59:35 CST 2016

Total time taken to generate the page: 0.07622 seconds