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 classes_main_frame

Description: Call this procedure from the Classes menu item in the top nav bar. It will load into the 'main' frame. The classes_left_nav should load into 'classes_left' frame; 'classes_list' should load into 'classes_main' frame.

Sample Screen

classes_main_frame.gif

Sample Code

 CREATE OR REPLACE PROCEDURE classes_main_frame
  AS
BEGIN
------------------------------------------------------------------------------

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

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

<FRAMESET COLS="20%,*">
  <FRAME SRC="classes_left_nav" NAME="classes_left">
  <FRAME SRC="classes_list" NAME="classes_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