1 Reply Latest reply on Jul 14, 2010 5:29 AM by Jasmin Charbonneau

    call stored procedure

    l10nel-CTS

      Hi:

      I have a customer that wants to eliminate direct queries to enterprise databases and invoke stored procedures. This will ease maintenance issues down the line if underlying schema is changed. At any rate the Call Stored Procedure returns the number of rows affected by the call, not the result set(s).  I'm hoping I'm missing something in the docs. There has to be a way to execute a stored procedure that returns the result sets.