https://community.qlik.com/t5/Integration-Extension-APIs/SQL-Error-while-executing-a-procedure-ErrorMsg-No-free-cursor/m-p/1707248#M12829 <P>Hi,</P><P>I'm executing a procedure inside a loop and passing some parameters through qlik sense. The procedure starts to run normally, but when it reaches 100 loaded lines, it shows the error below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="icaper_1-1591041313910.png" style="width: 516px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/34777iAC1D3DB7FE441E23/image-dimensions/516x361?v=v2" width="516" height="361" role="button" title="icaper_1-1591041313910.png" alt="icaper_1-1591041313910.png" /></span></P><P>&nbsp;</P><P>To call the procedure I'm using the syntax below:<BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="icaper_0-1591041135534.png" style="width: 632px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/34776iCABF4CFE221D01BF/image-dimensions/632x103?v=v2" width="632" height="103" role="button" title="icaper_0-1591041135534.png" alt="icaper_0-1591041135534.png" /></span></P><P>The database is not relational, it is object oriented (ASPEN IP21)</P><P>&nbsp;</P><P>Could someone help with this error please?</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 02:16:31 GMT icaper 2024-11-16T02:16:31Z https://community.qlik.com/t5/Integration-Extension-APIs/SQL-Error-while-executing-a-procedure-ErrorMsg-No-free-cursor/m-p/1707248#M12829 <P>Hi,</P><P>I'm executing a procedure inside a loop and passing some parameters through qlik sense. The procedure starts to run normally, but when it reaches 100 loaded lines, it shows the error below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="icaper_1-1591041313910.png" style="width: 516px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/34777iAC1D3DB7FE441E23/image-dimensions/516x361?v=v2" width="516" height="361" role="button" title="icaper_1-1591041313910.png" alt="icaper_1-1591041313910.png" /></span></P><P>&nbsp;</P><P>To call the procedure I'm using the syntax below:<BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="icaper_0-1591041135534.png" style="width: 632px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/34776iCABF4CFE221D01BF/image-dimensions/632x103?v=v2" width="632" height="103" role="button" title="icaper_0-1591041135534.png" alt="icaper_0-1591041135534.png" /></span></P><P>The database is not relational, it is object oriented (ASPEN IP21)</P><P>&nbsp;</P><P>Could someone help with this error please?</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 02:16:31 GMT https://community.qlik.com/t5/Integration-Extension-APIs/SQL-Error-while-executing-a-procedure-ErrorMsg-No-free-cursor/m-p/1707248#M12829 icaper 2024-11-16T02:16:31Z