-
Hi Folks,
I would like to know how to do a hostname validation in aPL/SQL block. That is given a perticular hostname extracted from the email address, I would like to confirm that it is a valid hostname.
Any ideas or thoughts would really be appreciated!
Thanx
Sam
Thanx
Sam
Life is a journey, not a destination!
-
I'll try to write this function tommorow, but me need more information about address structure.
-
Here is an example
xyz@hotmail.com is the email address
v_host := SUBSTR('xyz@hotmail.com',(INSTR('xyz@hotmail.com','@')+1));
I would want to validate that this is a valide address before proceeding with other things...
Sam
Thanx
Sam
Life is a journey, not a destination!
-
OK. I try rewrite this function from perl to pl/sql.
-
Shestakov,
I really appreciate your help. But here my curiosity is to find out whether I could use any utl package to do the validation inside the block instead of going out of the PL/SQL block.
Thanx
Sam
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|