Skip to Content

SAPA HANA call DML procedure

Hello,

I've created procedure to insert data to table, my goal it to call this procedure/pass input parameters using Calculation view. Nevertheless, following error prevent me of doing it:

SQL: EXPLAIN PLAN and CALL statement are not allowed: CALL for non read only procedure/function is not supported in the READ ONLY procedure/function: 

Is it possible to overcome it?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jan 24 at 10:09 AM

    You are trying to call a write enabled procedure in a calculation view? This is not possible. As the message says a calc. view is ready only and therefore cannot call a write enabled procedure. There is no option to insert data via a calc. view directly.

    If you share a little bit more about the context, maybe an alternative approach can be provided.

    Add comment
    10|10000 characters needed characters exceeded