PL/SQL (MOSC)

MOSC Banner

verify email address - find invalid characters

edited Sep 2, 2013 11:52PM in PL/SQL (MOSC) 4 commentsAnswered
our asia pacific region something entered email address with characters that is not acceptable by SMTP protocol, eg:
abc@abc.co.JP

(the character  jp were entered as JP)

we would like to write a plsql code to screen all single chars of the email address in a column table to find characters which has ascii < 32 or ascii>126

we have a function call hasWrongChar(p_email_address varchar2) to do a looping checking each single character if the ascii < 32, or ascii>126.

we try to test by calling:
haswrongchar( chr(200)||'asc')  - and the function return N (after checking, we found that chr(200) is not appended as the length function return 3)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center