I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction
Both the above mentioned tables hav a tim_upt column which s given as systimestamp
and strange it was the second insert reflects the correct timestamp whereas the UPDATE (Report table) s not reflecting the tim_upt
Though it is like this..
procedure set(tim_upt -- parameter varaible)
set different attributes,
tim_upt = systimestamp
Insert into A_R (......,tim_upt)values(....systimestamp);
when others then
It compiles without any error ,on run of test for that set of tables it is not throwing any exception and but the 1st table is not reflected with time of update ...
pls guide me on this