Databases Reference
In-Depth Information
Caution
As you can see, some additional procedures to disable constraints for referential integrity were used.
This is for testing purposes only, because we are talking here about an isolated case. In the real world, you would
create a validation checking whether such constraints exist.
You can now test this process and try to delete a couple of rows to see what you get. Figure 3-17
shows the selected rows to delete, and Figure 3-18 shows the result.
Figure 3-17.
Tabular Form—deleting records using custom process
Figure 3-18.
Tabular Form— deleting records—results
Run the following block of code in SQL Workshop in order to restore the EMP table:
BEGIN
tab form emp pkg.restore tables;
END;
Data Integrity
As already mentioned, there is much more work to do if you write your own custom processes.
Automatic processes created using the Tabular Form wizard ensure data integrity, and you would need
to do the same kind of thing manually in your own code. Automatic processes may display confusing
errors, but they are secure. It is not easy to write all of that code yourself since there are many details you
need to think of. My goal now is to show you how to do that and make you aware of the most important
things you should keep in mind.
