SAP HANA Procedure Read Only Limitation

[Former Member]

Hi,

I have created a procedure under my Schema with some DML statements

I am able to execute the the procedure in SQL editor with "CALL" option

But when I try to create a Calculation with same "CALL" command and try to activate the view it gives me below error

";Internal Error:Deploy Calculation View: 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 there any way around to this scenario/problem?

Thanks

[former_member184768 · Accepted solution]

Hi Nikhil,

If I understand correctly, you created a procedure which has "DML" statements which will insert / update some data and you wish to use this in a calculation view which is "SELECT" on data.

So every time when you fire select statement on the Calculation view, it will insert / update some data and then select the data.

I don't think that is allowed. May be you can return the dataset within the procedure which is also manipulating the data after data manipulation is done.

Regards,

Ravi

[Former Member]

Hi Nikhil,

While creating Procedure use this syntax

Create procedure "schema","abc"

() LANGUAGE SQLSCRIPT As

Begin

----

End;

i guess you are creating procedure with read mode, that is why its not allowing you. try this!!!

Thnkss

Kulwinder

[Former Member]

Procedure is created with the standard syntax, but still the problem exists