I have a procedure that takes a few parameters and parses them for inserting in a table for logging purposes. Except for the date / time the table entries can be the same in many rows. For unit testing, I want to check that there is a row inserted with the given data after the setup. So in the startup process I execute:
v_Datetime := sysdate;
In the validation process I attempt to identify the row as being inserted.
WHERE USER_PERM = P_USER_NBR
AND FUNC_TYPE = PFUNC_TYPE
AND v_Datetime < to_DATE(LOG_VAR_DATE || ' ' || LOG_VAR_TIME, 'MM-DD-YYYY HH24:MI:SS');
SQL Developer UniTest sees v_Dateime as an invalid identifier. Is there a way to get the value of a variable which was populated in startup to the validation process?