This discussion is archived
0 Replies Latest reply: Aug 27, 2013 1:55 AM by SAYYED RSS

Oracle Apex server issue

SAYYED Newbie
Currently Being Moderated

Hi,

 

Please answer me,  I don't know how the process flow in ORACLE APEX.

 

I am having form page with two process i.e

 

1. auto DML process on parent table (APP_MASTER) which performs DML automatically depends on button  Create, Delete, Update.

2. one more process to delete child records from child table APP_DETAILS when Delete button click,

 

there is record with app_id=109 in master table APP_MASTER , and this record references hundreds(800) of child records  in child table APP_DETAILS.

 

when user click on DELETE button to delete this records,Consider in mid of child records deleting(500 records are deleted)  suddenly server goes down(or server has some  issue).

in this case ,

I would like to know whether rollback will work on deleted child records.

 

I mean will i get back those deleted child records(500).

 

 

Thanks and regards,

Ibrahim Sayyed.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points