Oracle Web Application Programming for PL/SQL Developers
Solutions Specification for students_left_nav
Description: The left nav bar menu for Students. Load into 'students_left_nav' frame.
Sample Screen
Sample Code
CREATE OR REPLACE PROCEDURE students_left_nav
AS
BEGIN
------------------------------------------------------------------------------
-- FILE : students_left_nav.sql
-- CREATED BY : Solomon Morse
-- CREATED BY DATE: January 12, 2003
-- URL : students_left_nav
------------------------------------------------------------------------------
htp.p('
<HTML>
<HEAD>
<TITLE>Student Left Nav</TITLE>
</HEAD>
<BODY>
<TABLE BORDER="0" WIDTH="100%">
<TR>
<TD ALIGN="center"><A HREF="search_student" TARGET="students_main"><SMALL><FONT
FACE="Arial">Search Student</FONT></SMALL></A>
</TD>
</TR>
<TR>
<TD ALIGN="center"><A HREF="student_personal_info" TARGET="students_main"><SMALL><FONT
FACE="Arial">Add/Edit Student</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
- main_frame (15.2)
- top_menu (13.3) / (15.2)
- splash (13.1)
- student_main_frame (6.3)
- students_left_nav (6.3)
- search_student (12.4)
- get_student (12.4)
- student_list (12.4)
- student_personal_info (12.4)
- student_zipcode (18.5)
- update_student (18.5)
- 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)
- classes_main_frame (6.3)
- classes_left_nav (6, Building App)
- classes_list (6, Building App)
- classes_location (13.4)
- classes_location_update (13.4)
- set_cookie (15.2)
- get_cookie (15.2)
- cookie_exists (15.2)
- visitor_name (15.2)
- process_visitor_name (15.2)
- student_list_update (not in book)