OraFAQ Forum: SQL & PL/SQL » Oracle 9i UTL_SMPT gives different send time to actual send date

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 9i UTL_SMPT gives different send time to actual send date

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 9i UTL_SMPT gives different send time to actual send date [message #220304]

Tue, 20 February 2007 03:06

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

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	MOD_PLSQL
Next Topic:	Session Information & SQL Call

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 18:44:02 CST 2024