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?.
