The procedure being tested actaully modifies a column in table .This column is of DATATYPE NUMBER.
I tried this way :
INITIALISATION SECTION : v_before NUMBER :=
POST EXECUTION SECTION : v_after NUMBER :=
Then in the Edit Test >> Outcomes
I wrote a query like –
SELECT v_after -v_before FROM DUAL and compared it to 0 (ZERO).
To my dismay , i found v_after = v_before. [:^)]
Actual column in the table is getting modified.[Y]
Not sure , how foes POST EXECUTION SECTION works ?Please explain.
Any other solution to this problem statement , please suggest.