1 Reply Latest reply: Aug 2, 2012 7:56 AM by Philip Munz RSS

    oracle insert/update stored procedure

    Philip Munz

      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.

       

      loadskipt_settings.png

      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