Understanding Oracle APEX 20 Application Development: Think Like an Application Express Developer

© Edward Sciore 2020

E. ScioreUnderstanding Oracle APEX 20 Application Developmenthttps://doi.org/10.1007/978-1-4842-6165-1_7

7. Processes

Edward Sciore¹ 

(1)

Newton Center, MA, USA

 

As you have seen, it is possible to write highly functional web pages using only items, reports, and charts. But to implement anything more complex, you have to be able to perform calculations and interact with the database more generally. The notion of a process addresses both issues. This chapter examines some typical situations that require the use of processes and introduces the basics of PL/SQL so that you can write your own code to implement these processes. It also examines the pitfalls you might encounter when writing PL/SQL code, such as the possibility of lost ...