Oracle Database ASP

Results 1 to 2 of 2

Thread: Oracle Database ASP

  1. #1
    Join Date
    Dec 1969

    Default Oracle Database ASP

    I Have a Oracle Database that i am inserting info into With asp I have a Customer ID, it pulls from a sequence, how would i get the ID that was just created to insert into other tables.

  2. #2
    Join Date
    Dec 1969

    Default RE: Oracle Database ASP

    Slappy,<BR><BR>After the insert, you can select the max(Customer ID) from first table you inserted into, then use that. This will only work if numbers are consecutive and there is no chance of multiple users inserting at the same time.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts