Oracle® Web Application Programming for PL/SQL® Developers

Unit 18.5. Write and Reuse Modular Components

Reuse Code for Insert and Update

In Chapter 12, “Working with PL/SQL Server Pages (PSPs),” you created a PSP, student_personal_info.psp, that allows a user to edit an existing student, based on the values of first name and last name parameters input into another PSP, search_student.psp. When a first name/last name combination for a student yields a matching result from the database, then the resulting form painted by the procedure, student_personal_info.psp, displays the personal information for that student. If the submitted values yield no matching result from the database, then the form that is painted by student_personal_info.psp is a generic input form, ready for a new student to be inserted ...