I am trying to add some peoples detail's to my Oracle database, through ASP. I have set up the form, and text boxes for each indivdual fields, everything inserts fine apart from their ID, as this is a sequence in oracle. So a number can be inserted automatically, rather than allowing the user to insert there own ID.

Any ideas how to make my asp page generate the sequence for the new ID?