Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 07, 2017 at 08:45 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded