Oracle Web Application Programming for PL/SQL Developers

Solutions Specification for process_visitor_name

Description: Create the procedure process_visitor_name, the action of the form in visitor_name. Set a cookie called VISITOR that stores the visitor name passed in. To set the cookie, utilize the set_cookie procedure from this chapter. Then paint a page with a hyperlink to the main_frame procedure.

Code

  CREATE OR REPLACE PROCEDURE PROCESS_VISITOR_NAME
    (p_visitor_name IN VARCHAR2)
  IS
--------------------------------------------------------
-- FILENAME:     process_visitor_name
-- FILEDATE:     01.20.2003
-- CREATED BY:   Susan Boardman
-- DESCRIPTION:  Sets cookie for visitor name and 
--               paints link to enter application
-- URL        :  process_visitor_name
--------------------------------------------------------
  BEGIN
     set_cookie('VISITOR',
                 p_visitor_name,
                 sysdate+5);
     htp.p('<HTML>
            <HEAD><TITLE>Thank You</TITLE></HEAD>
            <BODY>
             Click <A HREF="main_frame">here</A> to
             enter the application.
            </BODY>
            </HTML>');
  EXCEPTION
    WHEN OTHERS THEN
    htp.p('An error occurred in PROCESS_VISITOR_NAME: '
           ||SQLERRM);
  END;

Select a Sample Application Code Unit

  1. main_frame (15.2)
  2. top_menu (13.3) / (15.2)
  3. splash (13.1)
  4. student_main_frame (6.3)
  5. students_left_nav (6.3)
  6. search_student (12.4)
  7. get_student (12.4)
  8. student_list (12.4)
  9. student_personal_info (12.4)
  10. student_zipcode (18.5)
  11. update_student (18.5)
  12. instruct (Package Spec and Body)
    • grade_calc (9.2)
    • v_font (9.4)
    • c_instruct_list (9.4)
    • inst_tbl_type (9.4)
    • instruct_table (9.4)
    • [PL/SQL block to load instruct_table] (9.4)
    • instruct_personal_info (11.3)
    • instructor_list_info (11.3)
    • showzip (11.3)
    • instructors_frame (11.1)
    • instructors_left_nav (11.1)
    • update_instructor (11.2)
    • instructor_list_class (11.3)
    • instruct_classes (11.3)
    • student_list (11.2)
  13. classes_main_frame (6.3)
  14. classes_left_nav (6, Building App)
  15. classes_list (6, Building App)
  16. classes_location (13.4)
  17. classes_location_update (13.4)
  18. set_cookie (15.2)
  19. get_cookie (15.2)
  20. cookie_exists (15.2)
  21. visitor_name (15.2)
  22. process_visitor_name (15.2)
  23. student_list_update (not in book)

Main Solutions Page