>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!
Try using SYSDATE.
http://oracleadvisor.com/documentation/oracle/database/11.2/timesten.112/e13070/ttsql247.htm
If it's not broken, fix it until it is.
My Blog