Error making an outgoing call within a SELECT loop.

79 Views

Hello ABAPpers,

In my custom application, an external .NET program invokes a custom RFC. This custom RFC processes some queries and sends the records back to the .NET program. As the number of records are more than 10 million, the RFC sends the records in batches of 1000. Here is the pseudo ABAP code:

SELECT blah

IF ROWCNT = 1000.

CALL FUNCTION CLIENT_RFC DESTINATION 'BACK'

ROWCNT = 0.

ENDIF.

ENDSELECT.

When the RFC executes, CLIENT_RFC is invoked as expected. However, once we return from CLIENT_RFC, the ABAP program terminates with an error "Invalid interruption of selected database when accessing..."

It appears that the SELECT mechanism does not like making outgoing calls:-(.

Can someone please enlighten me on how to fix this problem? I am hoping there is some way to instruct the database not to interrupt itself.

Thank you in advance for your help.

Sheetal