Hi,

The insert statement in your after update trigger PV.UPDATE_GLOBAL_LOG does not contains the column TOTAL_TIME. I wonder how the insert st. is working ..... anyway just update the trigger to include the following insert statement :

insert into global_users_log (pvid, barnd, login_time, logout_time, total_time) values(:new.pvid, :new.branding_id, :new.login_time, :new.logout_time, NVL(:NEW.logout_time,0) - NVL(:NEW.login_time,0) );

This should work.

In triggers always use NVL functions when dealing with numerical values. Numeric columns may have NULL values.

Good Luck.

Pinakin.