Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
to write to an Oracle database from qlikview with script? it's possible?
yes in the script it is possible...create a connection and then fire your query
sql insert into …
sql update tbl
sql call procname() etc.
you can also pass variables to these
sql call procname($(par1)) for example
Souad, there is another step involved here, in the Script Editor, you will need to go to the Settings tab, lower left area of the dialog, and in those tab settings, set the DB read write and you may need to set allow execute as well. I believe that should cover things. Please be sure you thoroughly test things before putting into production.
Oh, and since this is Oracle, there is a good chance the account running things may need some extra security rights in the Oracle side as well, in particular if you are using Publisher to run things...
Regards,
Brett