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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to save multiple regions data with one button ?

I am trying to create a form. It will contain 6 different regions for 6 different tables.
Like Personal_info, Official_info, Education_info, Experience_info, Image, Other_info. All table has a relation by employee_id.
But the problem is when I try to save the form it inserts data only in the Personal_info table.

I also tried manually creating a process in the save button with PL/SQL INSERT code which event is after submit page. But this one doesn't insert IMAGE data . Instead, it gives an error like "Error: ORA-01465: invalid hex number". But if I comment out the Image region and the insert code for IMAGE it gives no error and inserts all data.

I want to save all the data with one save button. Where it will sequentially insert data into tables. If I need to use dynamic action then what it would be please give some clue.
Please Help me out.

#apex23c #multiple #region #save #Button

This post has been answered by Ed Jones-Oracle on Nov 7 2023
Jump to Answer
Comments
Post Details
Added on Nov 6 2023
4 comments
374 views