hrs Specialised Training to meet your needs

Home Up The Team Public Courses Customised Consultancy

portal

                         

Developing using Oracle Portal Release 2

Assumptions and pre-requisites

Delegates are programmers with some experience of programming in Oracle 7 and/or using basic PL/SQL and SQL in Oracle 8.

Course Outline

Oracle 8i/9i and the Web

  • Apache Listener
  • Configuring Apache for static web pages
  • Configuring Apache for PL/SQL

Oracle9iAS Architecture

  • Basic Services
    • CGI-BIN
    • PERL
    • PL/SQL and PSP
    • JServ
  • Oracle9iAS Containers for J2EE (OC4J)
    • EJB
    • JSP
    • SSI
    • Servlets
      • general servlets
      • OJSP
      • Forms Listener
      • Oracle9iAS Portal

Building PL/SQL web pages

  • Using the PL/SQL Web toolkit (HTP, HTF et al)
  • Using PL/SQL Server Pages

Oracle Portal

  • What is Oracle Portal
  • How Oracle Portal works - the PPE
  • Portal from an end-users perspective

Basics of developing Oracle Portals

  • Summary of installation considerations
  • Summary of portal accounts
  • Key Development Interfaces
    • Portal Home Page
    • Navigator

Portal Pages

  • What is a Portal Page?
  • Creating Portal pages
  • Setting up Access Control
  • The Portal Administrator
  • The Portal Page Administrator
  • Regions
  • Items and Portlets
  • Items and Portlets provided by Oracle
    • Navigation page - Sample Banner
    • Built-in Navigation

Portal Items

  • Adding items to a standard page
  • Common attributes
  • File item
  • URL item
  • Text item
  • Image item
  • PL/SQL item
  • Page Link item
  • Image Map item
  • Zip File item

Portal Components

  • What is a component
  • Setting up a provider developer environment
  • Overview of the basic components available
    • Chart
    • Data Component
    • Calendar
    • Dynamic Page
    • Hierarchy
    • Menu
    • Frame Driver
    • Link
    • List of Values
    • URL
    • XML

Creating an Oracle Portal Form

  • Creating a form based on a table or view
    • Specifying name and other basic information
    • Formatting and Validation Options
    • Adding PL/SQL to execute on successful DML
    • Dealing with buttons and columns
  • Additional PL/SQL code to improve look and feel
  • Adding a form to a Portal Page
  • Creating Master-Detail forms
  • Creating a Form based on a procedure
  • Uploading pictures using a Form

Creating an Oracle Portal Report

  • Explore the rich set of options
    • QBE
    • Query Wizard
    • SQL Query
  • Embedded HTML
  • QBE allows DML

Building an Oracle Portal web application

  • Bringing it all together
[RETURN TO LIST OF COURSES]

 

[Home] 

Send mail to pleasering@oracle-training.co.uk with questions or comments about this web site.
Copyright © 2003 hrs
Last modified: February 11, 2003