>>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.htmThat should point me in the right direction...thanks.
ICQ 10556 (ya), 254117