Error ORA-01456 Qlik Sense

[spividori]

Hi.

When I want to execute an oracle procedure in the qlik sense script:

SQL CALL gQlik.CAL_setParamForSelectFromOF();

I get the following error:

The following error has occurred:

Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 20001, ErrorMsg: [Oracle][ODBC][Ora]ORA-20001: Error in generic setter [e9] ORA-06512: in "GLOBAL.GR_EXPORT_SQL_PQ", line82 ORA-01456: you can not perform insert / delete / update operations in a transaction READ ONLY ORA-06512: in "GLOBAL.GR_EXPORT_SQL_PQ", line129 ORA-06512: in "GQLIK.CAL_SETPARAMFORSELECTFROMOF", line 3.

In qlikview the solution is:

Inside QliKView script editor - in the "Setiings Tab", check "Open Databases in Read and Write Mode"

or in the connection string add the parameter: "Mode is write".

Here the question: how is that resolved in qlik sense?.

Regards.

[Anil_Babu_Samineni]

Is that the procedure name in sql as gQlik.CAL_setParamForSelectFromOF()

Do you have DB permissions? Can you try to load like

Exec gQlik.CAL_setParamForSelectFromOF

Or

Grant Exec gQlik.CAL_setParamForSelectFromOF

[spividori]

Hi.
Thanks for answering.
I will question the database administrator on the subject of permissions.

Regards.

[spividori]

Hi.
According to the administrator I have DB permissions, but it's not work!!!.

Regards.