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 ...

Get Oracle® Web Application Programming for PL/SQL® Developers 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.