BW 5.1.3 JDBC Call Procedure does now show result set when executing Stored ProcedurefromMSSQL server or Sybase12.5(sample stored procedure (sp.txt) is attached herewith)

BW 5.1.3 JDBC Call Procedure does now show result set when executing Stored ProcedurefromMSSQL server or Sybase12.5(sample stored procedure (sp.txt) is attached herewith)

book

Article ID: KB0087690

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Resolution:
Modify the SP by using 'SET NOCOUNT ON' within the procedure  and execute the same from BW.
It would show the resultset.

Issue/Introduction

BW 5.1.3 JDBC Call Procedure does now show result set when executing Stored ProcedurefromMSSQL server or Sybase12.5(sample stored procedure (sp.txt) is attached herewith)

Attachments

BW 5.1.3 JDBC Call Procedure does now show result set when executing Stored ProcedurefromMSSQL server or Sybase12.5(sample stored procedure (sp.txt) is attached herewith) get_app
Powered by Wolken Software