cancel
Showing results for 
Search instead for 
Did you mean: 

Getting error while calling a SP from FreeHand SQL in Webi

0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

I was able to successfully call SP using the following syntax:

BEGIN

procedure_name(:cbo);

END;

pete_rock
Discoverer
0 Kudos

used the same syntax and but got the same error

Answers (1)

Answers (1)

ayman_salem
Active Contributor

see KBA 2248236 - Free-hand SQL with DDL statements in Web Intelligence

https://launchpad.support.sap.com/#/notes/2248236

.....

  • Web Intelligence does not support certain DDL SQL keywords or commands in FHSQL SQL statements.
  • The unsupported DDL SQLs keywords and commands are:
  1. DROP TABLE [table].
  2. TRUNCATE TABLE [table].
  3. DELETE FROM [table] WHERE [condition].
  4. CREATE TABLE [table].
  5. ALTER TABLE [table].
  6. INSERT.
  7. UPDATE.

.......

0 Kudos

Hi, i cannot access the link that you shared.

Also, i am not using any of the commands that you mentioned, do you mean these commands cannot be used in a Procedure while using FHSQL?

nscheaffer
Active Contributor
0 Kudos

You cannot change data in any way from BusinessObjects either directly in your free-hand SQL statement or within a stored procedure called from a free-hand SQL statement. The use of temp tables or table variables is not allowed either.