SAPA HANA call DML procedure

[former_member601404]

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?

[pfefferf]

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.