I have a table called planet_a1 with columns
module_name
query_to_get_expected_results
query_to_get_actual_results
query_to_get_diff
I must write a procedure that gets the module name
query the expected results
query the actual results
and get the diff
if diff is greater than zero
then email diff
is this proc below correct? Please advise
declare
l_module pls_integer := 'LFACS_REFRESH';
l_expected number(2);
l_actual number(2);
l_diff number(2);
cursor get_values is
select * from planet_al;
for i in v_cursor
loop
begin
execute immediate 'select i.expected_query_results'
into l_expected
using l_module ;
execute immediate 'select i.query_actual_results'
into l_actual
using l_module;
execute immediate 'select i.query_to_get_diff'
into l_diff
using l_module;
if l_diff > 0
then