I have a form that users fill out and then is submitted to my oracle database. A trigger is setup to assign an ID # each time data from the form is submitted. I then want to return to the user the ID # for their form so they can check the status later. My problem is that I am discovering that the most recent insert is not always the last value. For example if I insert five forms and then display all the ID #'s they might look something like this, with 5 being the last ID # inserted.
Is this normal? To display the case number to the user I was just creating a record set of the ID's and displaying the last value, but after testing it, that is not going to work. Any suggestions on how I can display the ID # back to the user? (Maybe I should be asking this in the ASP area?) This is my first time using oracle so I am not sure how everything works quite yet. Thanks for the help
Correct. You cannot rely on physical order of records in the database. For example, if there is space near the "start" of the table (e.g. after deletion of some records) then a new insert may be placed there rather than at the end.