AnsweredAssumed Answered

Unable to retrieve result set from database

Question asked by SARANG GAIKHAR on Aug 22, 2017
Latest reply on Aug 24, 2017 by SARANG GAIKHAR

Hi,

     I'm trying to retrieve result set from DB for Stored Procedure using SQL lookup in map shape. For that I created Stored procedure in DB with parameters ENAME & SAL and declared to execute with query SELECT ENAME FROM EMP WHERE SAL=?. 

    In SQL command line its working fine but boomi I'm unable to take output as no.of records, it throws error. (Error image mentioned in attachment).

Outcomes