How to do a hostname validation in a PL/SQL block
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to do a hostname validation in a PL/SQL block

  1. #1
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    I'll try to write this function tommorow, but me need more information about address structure.

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    OK. I try rewrite this function from perl to pl/sql.

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
  •  


Click Here to Expand Forum to Full Width