Skip to Content
0
Former Member
Jul 16, 2008 at 12:07 PM

Problem with native SQL cursor in generic data source

16 Views

Hi, All!

I am implementing generic data source based on FM.

Because of complicated SQL I canu2019t use Open SQL and RSAX_BIW_GET_DATA_SIMPLE-example u201Cas isu201D.

So, I have to use Native SQL. But Iu2019ve got a problem with a cursor. When I test my data source in RSA3, everything is Ok. But, if I start appropriate info-package, I get error u201CABAP/4 processor: DBIF_DSQL2_INVALID_CURSORu201D. It happens after selecting of 1st data package in line u201CFETCH NEXT S1 INTOu2026u201D. It seems to me that when system performs the second call of my FM the opened cursor has already been disappeared.

Did anyone do things like this and what is incorrect?

Is it real to make generic data source based on FM with using Native SQL open, fetch, closeu2026