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!

How do you retrieve the ID given to a new submitted form/record during an INSERT operation?

M.EmmanuelApr 24 2016 — edited Apr 25 2016

I have created a form page which inserts a record into a table.

The record is properly inserted but I would like to retrieve the ID primary key value so the user stays in the same form page but with the right ID populated into a hidden field.

I guess I have to submit and create a branch to the same page, but how do I retrieve the ID field populated by the database via trigger/sequence during the INSERT operation?

I am using Universal Theme, Oracle XE 11g Release 2 and APEX 5.0.3.00.03.

Thanks,

This post has been answered by ReemaPuri on Apr 25 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 23 2016

Added on Apr 24 2016

#apex-discussions, #session

10 comments

2,415 views