on 02-04-2020 5:35 AM
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.
I was able to successfully call SP using the following syntax:
BEGIN
procedure_name(:cbo);
END;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
see KBA 2248236 - Free-hand SQL with DDL statements in Web Intelligence
https://launchpad.support.sap.com/#/notes/2248236
.....
.......
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.