Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 9i UTL_SMPT gives different send time to actual send date
Oracle 9i UTL_SMPT gives different send time to actual send date [message #220304] Tue, 20 February 2007 03:06 Go to next message
GeoffP
Messages: 1
Registered: February 2007
Junior Member
Hi

We have an Oracle 9i PL/SQL process on Unix that sends a message to users:

'Process started at HH:MI'. This works fine. Time is right.

It is received in Outlook with a sent date an hour in the future....

If I use mailx to send a similar message all times are fine.

Any ideas?

Thanks

Geoff
Re: Oracle 9i UTL_SMPT gives different send time to actual send date [message #222898 is a reply to message #220304] Tue, 06 March 2007 21:48 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
I am not sure how to help but Oracle only knows the date/time as told to it by the server. If your o/s has an invalid data/time Oracle will too.
Previous Topic: MOD_PLSQL
Next Topic: Session Information & SQL Call
Goto Forum:
  


Current Time: Sun Dec 11 04:27:49 CST 2016

Total time taken to generate the page: 0.23876 seconds