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 students_main_frame

Description: Called from the Students menu item in the top nav bar. Load into 'main'frame. Initial pages for the two frames are 'students_left_nav' in the 'students_left_nav' frame; 'student_search' in 'students_main' frame.

Sample Screen

students_main_frame.gif

Sample Code

CREATE OR REPLACE PROCEDURE students_main_frame
  AS
BEGIN
------------------------------------------------------------------------------

-- FILE           : students_main_frame.sql
-- CREATED BY     : Solomon Morse
-- CREATED BY DATE: January 12, 2003
-- URL            : students_main_frame

------------------------------------------------------------------------------
   htp.p('

<FRAMESET COLS="20%,*">
  <FRAME SRC="students_left_nav" NAME="students_left_nav">
  <FRAME SRC="student_search" NAME="students_main">
  <NOFRAMES>
  <BODY>
  <P>THIS PAGE USES FRAMES, BUT YOUR BROWSER DOESN''T SUPPORT THEM.</P>
  </BODY>
  </NOFRAMES>
</FRAMESET>

');

EXCEPTION
   WHEN OTHERS THEN
   htp.p('An error occurred on this page. 
          Please try again later.');
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