topic Runtime Err while fetching records based on Cursor. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/runtime-err-while-fetching-records-based-on-cursor/m-p/7606140#M1568818 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have used cursor to fetch records. It is working fine if used alone but if i do other operations, it is giving me a dump.</P><P></P><P>Issue:</P><P>Open Cursor is defined. </P><P>Fetch Cursor is used to fetch data - 500 records in a go.</P><P></P><P>Additional Ops.</P><P>Create Variants using RS_CREATE_VARIANT.</P><P>Use BP_JOB_CREATE to create jobs and close it using JOB_CLOSE.</P><P></P><P>When i have to do this additional ops., something happens to the cursor and i get this error - DBIF_RSQL_INVALID_CURSOR.</P><P></P><P>Is there anything that I'm missing in the process.</P><P></P><P>Thank you.</P></BODY></HTML> Fri, 31 Dec 2010 06:52:47 GMT Former Member 2010-12-31T06:52:47Z Runtime Err while fetching records based on Cursor. https://community.sap.com/t5/application-development-and-automation-discussions/runtime-err-while-fetching-records-based-on-cursor/m-p/7606140#M1568818 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have used cursor to fetch records. It is working fine if used alone but if i do other operations, it is giving me a dump.</P><P></P><P>Issue:</P><P>Open Cursor is defined. </P><P>Fetch Cursor is used to fetch data - 500 records in a go.</P><P></P><P>Additional Ops.</P><P>Create Variants using RS_CREATE_VARIANT.</P><P>Use BP_JOB_CREATE to create jobs and close it using JOB_CLOSE.</P><P></P><P>When i have to do this additional ops., something happens to the cursor and i get this error - DBIF_RSQL_INVALID_CURSOR.</P><P></P><P>Is there anything that I'm missing in the process.</P><P></P><P>Thank you.</P></BODY></HTML> Fri, 31 Dec 2010 06:52:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/runtime-err-while-fetching-records-based-on-cursor/m-p/7606140#M1568818 Former Member 2010-12-31T06:52:47Z Re: Runtime Err while fetching records based on Cursor. https://community.sap.com/t5/application-development-and-automation-discussions/runtime-err-while-fetching-records-based-on-cursor/m-p/7606141#M1568819 <HTML><HEAD></HEAD><BODY><P>What are you doing in the 'Additional Ops.'?</P><P>Any commits or rollbacks there?</P><P>Cursor is closed on database commit or a database rollback an these happen implicitly eg. when completing dialog step, calling function module , ....</P></BODY></HTML> Fri, 31 Dec 2010 12:40:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/runtime-err-while-fetching-records-based-on-cursor/m-p/7606141#M1568819 former_member182670 2010-12-31T12:40:23Z