Error ORA-01456 Qlik Sense

spividori — Sat, 16 Nov 2024 06:49:21 GMT

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.

Re: Error ORA-01456 Qlik Sense

spividori — Fri, 18 Jan 2019 12:38:02 GMT

Any suggestions, please!.

Regards.

topic Error ORA-01456 Qlik Sense in Management & Governance

Error ORA-01456 Qlik Sense

Re: Error ORA-01456 Qlik Sense