>>>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>
>That should point me in the right direction...thanks.
You're welcome.
If it's not broken, fix it until it is.
My Blog