CHAPTER 8

image

Data Validation

When a process writes to the database, it typically takes its values from the session state. An application developer must therefore ensure that the session state values are valid, to ensure that the process was used appropriately and to preserve the integrity of the database. This chapter examines three aspects of a valid session state — constraint preservation, input validation, and process validation — and shows you how to implement them in an APEX application.

Constraint Preservation

The integrity of a database is important. The presence of an incorrect record not only reduces the value of any query involving that ...

Get Understanding Oracle APEX 5 Application Development, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.