Skip to Content
0

Facing issue when I am trying to use "WITH OVERVIEW" in SAP HANA Stored Procedure

Sep 05, 2017 at 06:05 PM

127

avatar image
Former Member

Hi,

I am using SAP HANA developer edition 1.0 SPS 12.

I am trying to use following command in Stored Procdure. But showing issue as “[workshop.sessiona.01.procedures:Sample5.hdbprocedure] Could not create catalog object: feature not supported; cannot use WITH OVERVIEW option for nested calls: line 16 col 102 (at pos 623)”

Command I am trying to use:

TBL_PAL_ARIMA_DATA_TBL2 = select * from "PAL"."STOCKS";

TBL_PAL_CONTROL_TBL = select * from "PAL_CONTROL_TBL";

TBL_PAL_ARIMA_MODEL_TBL =select * from "PAL"."PAL_ARIMA_MODEL_TBL";

CALL PAL.PAL_ARIMATRAIN_PROC(:TBL_PAL_ARIMA_DATA_TBL2, :TBL_PAL_CONTROL_TBL,:TBL_PAL_ARIMA_MODEL_TBL) WITH OVERVIEW;

Please help me to solve this issue.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Michael Healy
Sep 07, 2017 at 08:45 PM
1

WITH OVERVIEW is now disabled.

The reason we disabled "WITH OVERVIEW" in procedure after SP11 is "WITH OVERVIEW" does some updates into the temp table and the temp table should be managed by user or session. Nested call "with overview" can cause bloating of temp table creation, if it is used in a loop, and decrease the performance of outtermost call.

Share
10 |10000 characters needed characters left characters exceeded