Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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?
Kind regards
Philip
Hello,
solution is:
"Mode is write " in connect string:
ODBC
CONNECT32 TO [MICDW;DBQ=XXXXXXX] (XUserId is DJLJFDLKJDKLÖFLKÖFJD, XPassword is DFLHJ=DFKJKÖLKLDJF, Mode is write);
Philip
Hello,
solution is:
"Mode is write " in connect string:
ODBC
CONNECT32 TO [MICDW;DBQ=XXXXXXX] (XUserId is DJLJFDLKJDKLÖFLKÖFJD, XPassword is DFLHJ=DFKJKÖLKLDJF, Mode is write);
Philip