Error when executing stored procedure in FM

[yogeswari]

Hi,

I am getting the below error when i validate a stored procedure in Framework manager.

RQP-DEF-0179 The procedure call "G-N DB"..MOD."MRK_KRN_PKG.BUILD_MS_DATA"(:A_CONTRACT_NUMBER IN,:A_PERIOD_START_DATE IN,:A_PERIOD_END_DATE IN,:A_RETURN_CODE OUT) is unable to return a result set.

could anyone tell what is the reason behind this.  please provide your solutions as what can be done.

thanks,
yogeswari.

[saumil287]

Hi,
Check whether SP is update or select procedure?
OR
Input different values in the parameters and see the results.

[yogeswari]

Hi,

thanks for your response.  How to check the SP code?  I mean to say i dont have access to view the code of stored procedure.  In this case, what can be done?

Please suggest.

thanks,
yogeswari.

[navissar]

Hi,
Any SP ran from Cognos is expected to return something. If an SP only updates data, Cognos will throw an error because it expects a result set.
This can be easily bypassed by adding a bogus select statement at the end of the SP. However, you (Or someone with access) has to check and if needs be change the SP. This cannot be done from Cognos.

[yogeswari]

Hi,,

thanks for your response.
Will get back to you, if anything else is required.


thanks,
yogeswari.