We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE: [sap-dev] DEV: Database Cursor Usage

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by Dave Thornburgh (SAP JOAT)
on Nov 30 at 12:51 AM 		Mark this reply as helpfulMark as helpful
Kerum -

First, I swore I wouldn't respond to a nine year old post - but then I read your response and realized that yours was the ONLY answer, and you left out my favorite reason.

I have never needed OPEN CURSOR to avoid the side effects of COMMIT. On the other hand, I have needed it several times for programs that need to select millions of rows of data, but cannot hold all of that data in memory at the same time (as with SELECT ... INTO TABLE). I use a database cursor to read and process in smaller packages strictly to reduce memory consumption.

Dave

---------------Original Message---------------
From: kerum
Sent: Wednesday, November 24, 2010 3:11 AM
Subject: DEV: Database Cursor Usage

Hi,
you can use OPEN CURSOR (with addition WITH HOLD) and FETCH (with addition PACKAGE SIZE) to process data in packages and don't loose your cursor on database commit (as in normal SELECT ... ENDSELECT).
Look here for the example:
http://www.kerum.pl/infodepot/00016
regards,
Kris
__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Dave Thornburgh
SAP Development Enthusiast

Contributed 100 posts in a group to earn a Bronze Achievement
Related Content
Most Popular White Papers
In the Spotlight
Toolbox.com for iPhone: Ask Questions & Get Answers Anywhere. Use the New iPhone App
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language