write in Oracle database table

[ali_hijazi]

Hello
is there a way to write in an oracle database while running the script in Qlik sense?

[vincent_ardiet_]

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:

IF('$(vAckSuccessFlag)' = 'N') then

            SQL CALL pkg_dwh.pr_acksync;

            ...
 

[ali_hijazi]

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

[vincent_ardiet_]

No there is no need of a dataset in return.
We are also doing such command:

SQL alter session set NLS_DATE_FORMAT = 'DD-MON-RR';

[Lech_Miszkiewicz · Accepted solution]

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:

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/How-to...

cheers

[vincent_ardiet_]

Or use OLEDB 🙂

[ali_hijazi]

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?

[vincent_ardiet_]

You will have to do a loop across all rows of T and do your inserts one by one.