Re: Code to Validate email addresses

Hi

The definition is found in RFC 2822 Internet Message Format (ftp://ftp.isi.edu/in-notes/rfc2822.txt)

Oweson Flynn wrote:

>Hi,
>
>We have implemented a form that emails reports. The user has to enter his
>email address.
>
>However, we are finding that a lot of users are entering incorrect and
>invalid email addresses.
>
>Obviously, we can do nothing if they enter an incorrect (but syntactically
>correct) email address.
>
>What I am looking for is:
>
>1) A definition of the syntactically correct format of an email address
>(from some sort of authoritative source)
>
>2) Hopefully some pl/sql code that will validate a sting to see if it is a
>valid email address.
>
>If anyone can assist, I would appreciate it!
>
>Regards
>Oweson Flynn
>_____________________________________________________________________
>"Tell me what you think, Captain, I'm all ears" - Spock
>
>Certified Oracle DBA
>The Flynn Consultancy
>Tel: 082-600-7-006
>Fax: (011) 782-9313
>EMail: oef_at_icon.co.za
>
>
>
>*******************************************************************
>
>This message may contain information which is confidential and subject to legal
>privilege. If you are not the intended recipient, you may not peruse, use,
>disseminate, distribute or copy this message. If you have received this message in
>error, please notify the sender immediately by email, facsimile or telephone and
>return and/or destroy the original message.
>
>*******************************************************************
>

-- 
Regards

Peter Gram

Miracle A/S 
http://MiracleAS.dk 
Tel: +45 2527 7107



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).