Oracle9iAS Portal Developer Kit
Installing the Java Stored Procedures Portlet Sample

The portlet sample displays content returned by Java stored procedures for various SHOW modes. This document explains how the PL/SQL portlet sample is packaged and how to install it.

### CONTENTS

This section describes the files included in this example. There are package specifications (.pks), package bodies (.pkb), Java source (.java), Java classes (.class), and an installation script (.cmd file).

Files

> hello_provider.pks: Detailed comments and headers for the Provider.

> hello_provider.pkb: Logic behind the Provider.

> helloworld_portlet.pks: Detailed comments and headers for the PL/SQL portlet using Java stored procedures.

> helloworld_portlet.pkb: Logic behind the PL/SQL portlet using Java stored procedures.

> HelloWorldJava.java: Java source file containing static methods which return content for the various SHOW modes.

> HelloWorldJava.class: Java class called by helloworld_portlet.pks.

> helloinst.sql: SQL script internally called by install.cmd to load the .pks and .pkb files.

> install.cmd: Main installation file that installs this sample (NT).

> install.sh: Main installation file that installs this sample (Unix).

Documentation

> installing.plsql.portlet.sample.using.java.stored.procedures.html : This document.

### SETUP

To give you a good understanding of what goes on behind the scenes, these instructions describe how to install the sample manually.

Installing the Packages

1. Locate provsyns.sql and change to that directory. For example:

   on NT C:\portal30\webdb30\admin\plsql\wwc

   Later, you will run this script to grant permission to call Oracle9iAS Portal APIs.

2. Create the schema where you will install the example:
   1. Login to SQLPLUS (e.g. sqlplus sys/change_on_install).
   2. Create a new schema (e.g. create user helloworldjava identified by helloworldjava;).
   3. Give it permissions (e.g. grant connect, resource to helloworldjava;).
3. Grant your schema permission to call Portal APIs:
   1. Login as the schema where your portal is installed (e.g. connect portal30/portal30;)
   2. Run provsyns.sql as the schema where your portal is installed (e.g. @provsyns.sql helloworldjava;)
   3. Exit SQLPLUS.
4. Install the sample:
   1. Set the environment variable ORACLE_HOME.
   2. Change to the directory where you unzipped this example ( e.g.on NT, D:\helloworldjava)
   3. Run the installation script from the command prompt.

   NT: install.cmd <provider_schema> <provider_schema_passwd> <connect_string>

   Unix: install.sh <provider_schema> <provider_schema_passwd> <connect_string>

Registering Your Provider

For Oracle9iAS Portal to display this Provider (and for your users to see its portlets), you need to register the new provider with Oracle9iAS Portal.

1. Login to Oracle9iAS Portal as a portal administrator.

2. Click the Administer tab.

3. Under the Administer tab, click on Add a Portlet Provider within the portlet called Provider.

4. Fill out Provider information for the sample:

   - Name: PL/SQL_Provider_Using_JavaStoredProcedures
   - Display Name: PLSQL_Provider_Using_JavaStoredProcedures
   - Timeout: 100
   - Timeout Message: Application Timed Out
   - Implementation Style: Database
   - Provider Login Frequency: Never
   - Register on Remote Nodes: No
   - Owning Schema: HELLOWORLDJAVA (or the name of the schema you created for this provider)
   - Package Name: HELLO_PROVIDER.
5. Click OK.

   Note: This registration can also be done programmatically. Please see the PL/SQL API Reference for more information.

For more information on this sample, read the article Developing PL/SQL Portlets Using Java Stored Procedures.

Revision history:

> September 26, 2001