SP:

Procedure  reporting.dbo.usp_Automation_GetFrameDetails  @barcode

       Example:
exec reporting.dbo.usp_Automation_GetFrameDetails @barcode = '0184956500500000'



DB Browse error:

GatewayException: SQL error for "exec reporting.dbo.usp_Automation_GetFrameDetails @barcode = '0184956500500000'
": A result set was generated for update.
	caused by SQLServerException: A result set was generated for update.

Ignition v7.9.8 (b2018060714)
Java: Oracle Corporation 1.8.0_171



Script:

call = system.db.createSProcCall("reporting.dbo.usp_Automation_GetFrameDetails_A")
call.registerInParam("barcode", system.db.BIGINT, '0184956500500000')
  
system.db.execSProcCall(call)
  
# Print the result to the console
results = call.getResultSet()
print results
py_res = system.dataset.toPyDataSet(results)
print py_res

Script returns:

>>> 
Dataset [0R ? 36C]
<PyDataset rows:0 cols:36>
>>>