cancel
Showing results for 
Search instead for 
Did you mean: 

HANA stored procedure

rhightower13
Participant
0 Kudos

I've created the following stored procedure in HANA and I'm able to call the procedure in HANA studio:


CREATE PROCEDURE  STOREDPROCEDURES."SALES"(

  OUT SALES STOREDPROCEDURES."SALES_ORDERS")

  LANGUAGE SQLSCRIPT AS

BEGIN

  SALES = SELECT * FROM "DEMO1"."DEMO1_SALES";

END;

When I search in Visual Composer, I can add the procedure to my model but when I test it I get the very unhelpful error: "Could execute stored procedure next" and no data.  My initial thought was there is something wrong with my procedure definition but I get the same error if I test one of the stored procedures delivered with HANA.

Any suggestions would be greatly appreciated!

Ross

View Entire Topic
talia_gurevich
Participant
0 Kudos

Hello Ross,

The issue should be investigated. The best channel for this is customer ticket.

Could you please open a customer ticket for EP-VC-CON component?

Thanks,

Talia