oracle insert/update stored procedure

Wed, 01 Aug 2012 13:21:39 GMT

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

Re: oracle insert/update stored procedure

Thu, 02 Aug 2012 11:56:08 GMT

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