This paper is the second of a two (2) part
series. Part 2 covers e-mail address validation using a 12 point PLSQL e-mail
addresses validation function.
Using the PLSQL function we cover e-mail
validation of addresses in both the wf_local_roles and wf_local_users objects
and in a number of base application objects that populate the workflow roles
and users objects.
The paper and the PLSQL function can be viewed or downloaded at the following addresses
PDF document, 500 Kb
http://www.piper-rx.com/pages/papers/email_validation_part_two.pdf
PLSQL, 8 Kb
http://www.piper-rx.com/pages/papers/piper_rx_email_validation.sql
-Gary