Note: You can view the full content of our pages on any browser or Internet device. However, our pages look best in browsers that support Web Standards.

Oracle Web Application Programming for PL/SQL Developers

Solutions Specification for visitor_name

Description: Create a procedure called visitor_name that displays a form asking for the user's name. The action of the form should be a procedure called process_visitor_name.

Sample Screen

visitor_name.gif

Sample Code

CREATE OR REPLACE PROCEDURE VISITOR_NAME
  IS
--------------------------------------------------------
-- FILENAME:     visitor_name
-- FILEDATE:     01.20.2003
-- CREATED BY:   Susan Boardman
-- DESCRIPTION:  Paints form to request visitor name
-- URL        :  visitor_name
--------------------------------------------------------
  BEGIN
    htp.p('<HTML>
           <HEAD><TITLE>Name, Please</TITLE></HEAD>
           <BODY>
           <H1>What is Your Name?</H1>
           <FORM NAME="visitor_name_form"
                 ACTION="process_visitor_name"
                 METHOD="POST">
             <INPUT NAME="p_visitor_name" TYPE="text" >
             <INPUT TYPE="submit" VALUE="Save">
           </FORM>
           </BODY>
           </HTML>
          '); 
EXCEPTION
  WHEN OTHERS THEN
  htp.p('An error occurred in 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