TYPE error_rectype IS RECORD (
To determine if function has executed succesfully I want to check the error records values.
I have initalized the record in the initialization section:
e_RECORD.sql_code := 0;
e_RECORD.description := 0;
e_RECORD.var1 := null;
e_RECORD.var2 := null;
e_RECORD.var3 := null;
I have also created an are-elements-equal-function with this query (and Generate Code):
select 0 as sql_code, 0 as description, null as var1, null as var2, null as var3 from dual
I have gone through all the generated code and it seems correct.
The last rows in the function are:
error_record.sql_code := 0;
error_record.description := 0;
error_record.var1 := null;
error_record.var2 := null;
error_record.var3 := null;
logger writes to a table, so I know that I get all the way to the end of the function.
Still the test failes with the message “Record from program does not match expected record”, what am I doing wrong??
Big thanks in advance for any help…
What am I missing? I am using the latest Beta version of QCT.
I have a function that returns an error record, defined like this: