go to post Omprakash Sharma · Nov 18, 2020 Hi Ramesh, There is no direct way to overcome this error. The best possible way is to catch the tSC error and set it to Ok do ..Adapter.DSNSet(DataSourceName) set sp = "{call sqlstoredprocedure(?,?,?)}"set tSC = ..Adapter.ExecuteProcedure(.pResults, .out, sp, "iii", p1,p2,p3) set errorText = $System.Status.GetErrorText(tSC) if (errorText [ "Invalid cursor state"){set tSC = $$$OK} Certifications & Credly badges:Omprakash has no Certifications & Credly badges yet.Global Masters badges:Omprakash has no Global Masters badges yet.Followers:Omprakash has no followers yet.Following:Omprakash has not followed anybody yet.
Hi Ramesh,
There is no direct way to overcome this error. The best possible way is to catch the tSC error and set it to Ok
do ..Adapter.DSNSet(DataSourceName)
set tSC = ..Adapter.ExecuteProcedure(.pResults, .out, sp, "iii", p1,p2,p3)
set errorText = $System.Status.GetErrorText(tSC)
if (errorText [ "Invalid cursor state")
{
set tSC = $$$OK
}