Omprakash is an Avid Reader. No contributions for 2024.
Without a doubt, there will be something to
share on the Community in 2025!
User bio
404 bio not found
Member since Nov 18, 2020
Posts:
Omprakash has not published any posts yet.
Replies:

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, .outsp"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.