I'm trying to insert / update tables in an oracle db during the load script. Therefore I wrote a stored procedure.
In Oracle (SQL Developer) it is working quite fine.
But in Qlikview I receive the error (Ora-01456) that insert/delete/update operations during READ ONLY transactions are not allowed.
Next step I checked that the Datasource is opened for write and read operations in the Settings of the load skript.
But I still receive the same error.
Using MS-Access I'm allowed to make updates / inserts via ODBC.
Can anyone please give me a hint how to fix this?