User bio
404 bio not found
Member since Nov 18, 2020
Posts:
Omprakash has not published any posts yet.
Replies:
show all 1
Omprakash Sharma · Nov 18, 2020 go to post

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.
Followers:
Omprakash has no followers yet.
Following:
Omprakash has not followed anybody yet.