topic Re: DB Cursor and RFC question in Application Development and Automation Discussions

DB Cursor and RFC question

Former Member — Wed, 19 Apr 2006 19:34:03 GMT

Hello everyone,

One question. Is there a way to work with db cursors via RFC calls? For example, I've to extract a huge table via a java program. So I've to call a FM and transfer 1000 datasets with each call of the FM. But how I can start with the last transfered line? I know with you use a cursor its no problem. But what happens if you call this FM via RFC with the cursor? I find now way to work with the cursor when I call the FM the second time.

Thanks for your help!

Regards Daniel

Re: DB Cursor and RFC question

Former Member — Wed, 19 Apr 2006 21:04:26 GMT

Pass the index number of the last record sent as a parameter from the sending system, then send it back on the next call. And so on...

Re: DB Cursor and RFC question

Former Member — Wed, 19 Apr 2006 22:46:53 GMT

Have you tried to open cursor with 'with hold' option?

From SAP Help

<i>With one exception, a database LUW is concluded when you close a cursor either explicitly or implicitly. The WITH HOLD addition in the OPEN CURSOR statement allows you to prevent a cursor from being closed when a database commit occurs in Native SQL.

</i>

Re: DB Cursor and RFC question

Former Member — Thu, 07 Feb 2008 19:46:31 GMT

Hi all,

Thx for all your answers. there is now solution to be sure to work with the db cursor over a rfc call. So don't try it, it's something like playing roulette

Regards,

Daniel

p.s.

sorry that I forgot to close this thread