Skip to Content
0
Feb 04, 2020 at 05:35 AM

Getting error while calling a SP from FreeHand SQL in Webi

197 Views Last edit Feb 04, 2020 at 05:36 AM 2 rev

Hi,

I am getting an error while calling a stored procedure using FreeHand SQL in a webi report that i have.

It says: A problem is encountered. The requested action cannot be completed. (Error: INF )

I have tried using EXEC/EXECUTE/CALL Procedure-name/Schema-name.Procedure-name but i still get the same error.

The procedure does not have any parameters and i am running a select statement after executing the procedure to get the updated data in the table. For example-

EXEC Procedure1;

Select * from Table1

Please let me know if i am doing anything wrong or if there is any other way to achieve the desired result.