Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Apex - Retrieve the generated ID (Primary key) after submission

User_B6DDOJul 24 2022

Hello all,

I have a question with my Apex form developed from the employees DB, including emp_ID which is a primary key - sequence generated from APEX for each record submitted.
what i need is : after filling out the employee information in the registration form, i need to retrieve the emp_ID that submitted and inserted to the database, i mean after submission i want an Alert message with the ID generated for this record or employee.

i have found the MAX(emp_ID) method , but it is not useful for my case and i have many end-users for the form.

Is there any process after submission to retrieve me the ID auto generated?
Please help
Thank you

Comments
Post Details
Added on Jul 24 2022
3 comments
2,203 views