We have an Oracle procedure that looks like this:
CREATE OR REPLACE PROCEDURE KPOPSLOGGER.KPOPS_Logger (E_Type NUMBER, A_Object NUMBER, MRN NUMBER ) AS
BEGIN
INSERT INTO KPOPSLogger.PHI_Event
(Event_Type, Application_Object, MRN, PHI_Item)
(SELECT E_Type, A_Object, MRN, PHI_Item
FROM KPOPSLogger.Application_Screen_PHI
WHERE Application_Object=A_Object) ;
END
...my problem is that there is a phi_event.event_time field (which is datetime) and I need to put the current datetime in that field in the above procedure. Anyone know how I can do that?
Thanks!
ICQ 10556 (ya), 254117