Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
is there a way to write in an oracle database while running the script in Qlik sense?
Hi @ali_hijazi
you will need to make some configuration changes if you want to execute non-select queries. This is documented on help side:
cheers
You can put what you want after the SQL keyword, of course it depends of the user rights of the account set in the connection.
For example, in my company, we are launching stored procedures to prepare the data or to acknowledge that we manage to do it, in order to receive incremental datasets.
Like this:
Hello thank you for your reply
what I want is read from a database (load data into memory)) then insert it in another database
now the script that you wrote above:
\SQL CALL pkg_dwh.pr_acksync
but the query after the SQL should return a result set; I cannot put insert into table;
kindly advise
No there is no need of a dataset in return.
We are also doing such command:
Hi @ali_hijazi
you will need to make some configuration changes if you want to execute non-select queries. This is documented on help side:
cheers
Or use OLEDB 🙂
it seems to work; I got the insufficient privileges from Oracle server
though I remember once I tried to have an insert statement and I got error from Qlik itself saying what sounded like the query has to return a result set
but now if I have a table T in memory (loaded in Qlik)
what would be the syntax to read rows from T and insert them into a database table?
You will have to do a loop across all rows of T and do your inserts one by one.