I’m building a long sync script from an API to our SQL Data Warehouse. I’m trying to get statistics of the script execution for follow-up and debugging purpose.
For that I’m using the sqlrowcount function but I’m having issues using it, not sure I’m using it as required by Query Tool 20.1.435 beta. Let’s make a trial on a short script:
create or replace table date_range_1@inmemorystorage
as
select *
from calendar@datadictionary
where day_date between to_date('01-01-2000', 'DD-MM-YYYY') and to_date('01-01-2015', 'DD-MM-YYYY')
create or replace table date_range_2@inmemorystorage
as
select *
from calendar@datadictionary
where day_date between to_date('01-01-2010', 'DD-MM-YYYY') and to_date('01-01-2020', 'DD-MM-YYYY')
declare
count varchar2;
begin
synchronize date_range_1@inmemorystorage
to date_range_2@inmemorystorage
with insert all except rowid$
identified by day_date
;
count := sqlrowcount;
dbms_output.put_line('number given by sqlrowcount: '||count);
end;
The DBMS output says:
number given by sqlrowcount: 0
whereas when launching directly the statement
synchronize date_range_1@inmemorystorage
to date_range_2@inmemorystorage
with insert all except rowid$
identified by day_date
Thank you for bringing this to our attention. The products Invantive Query Tool and Invantive Data Hub were indeed not yet released with a 20.1.444 SQL engine.