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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.