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_left_nav

Description: Load into 'classes_left' frame. Display the heading top menu item selected. Below, display the following hyperlinked menu item:

  1. Classes List - loads into 'classes_main'

Sample Screen

classes_left_nav sample screen

Sample Code

 CREATE OR REPLACE PROCEDURE classes_left_nav
  AS
BEGIN
------------------------------------------------------------------------------

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

------------------------------------------------------------------------------
   htp.p('
<HTML>
<HEAD>
<TITLE>Classes Left Nav</TITLE>
</HEAD>
<BODY>
<TABLE BORDER="0" WIDTH="100%">
  <TR>
    <TD ALIGN="center"><A HREF="classes_list" TARGET="classes_main"><SMALL><FONT 
FACE="Arial">Classes List</FONT></SMALL></A>
    </TD>
  </TR>
</TABLE>
</BODY>
</HTML>
');

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)