The following samples demonstrate the various features of Java Stored Procedures.

EJB Callout Sample [27-Jun-2003]
This sample illustrates invoking EJB components running under an application server from within a Stored Procedure. Currently, it is not possible to invoke an EJB directly from the database. This sample application discusses a workaround for this.
Download Now (JAR, 41KB)
Readme

Java Messaging Services Sample [03-Dec-2002]
This sample demonstrates Java Messaging Services by demonstrating how to create a message queue in the database and how to create a sender and receiver for the queue in Java Stored Procedure.
Download Now (JAR, 8KB)
Readme

Database Controlled Web Publishing Sample[01-Oct-2002]
This demo showcases a new design pattern for publishing non-frequently changing database content while automatically reflecting changes to the data no matter the origin of the changes. This portable design pattern integrates standard J2EE presentation logic in Oracle9iAS ( JavaServer Pages, and upcoming Temporary Java Cache - JSR 107) with Java based data logic in Oracle9i Database (Java Stored Procedures) to provide an order of magnitude performance increase for querying semi-static data such as product catalogs, price lists, et al.
Download Now (JAR, 307KB)
Readme
Source
Abstract

Java Stored Procedure Sample [01-Oct-2002]
This sample application demonstrates how to load, publish and access Java Stored Procedure using JDBC.
Download Now (JAR, 150KB)
Readme
Source

Java Stored Function Sample [01-Oct-2002]
This sample application demonstrates how to load, publish and access Java Stored Function using JDBC.
Download Now (JAR, 143KB)
Readme
Source

Java Stored Trigger Sample [01-Oct-2002]
This sample application demonstrates how Java Stored Triggers perform automatic database updates. The sample inserts data into a table which has a Java Stored Trigger to be executed on inserts.
Download Now (JAR, 142KB)
Readme
Source

Java Stored Procedure invoking PL/SQL Stored Procedure [01-Oct-2002]
This sample application demonstrates how a Java program can call a Java Stored Procedure which in turn calls a PL/SQL Stored Function.
Download Now (JAR, 64KB)
Readme
Source

PL/SQL Stored Procedure invoking Java Stored Procedure [01-Oct-2002]
This sample application demonstrates how a Java program can call a PL/SQL Stored Procedure which in turn calls a Java Stored Procedure.
Download Now (JAR, 64KB)
Readme
Source

Invoking Java Stored Procedure from a PL/SQL Anonymous block [01-Oct-2002]
This sample application demonstrates how to call a Java Stored Procedure from a PL/SQL Anonymous block. Anonymous Blocks are used for accessing data from SQL*Plus, OCI programs, etc.
Download Now (JAR, 137KB)
Readme
Source

Java Stored Procedure as SQL Object Type method [01-Oct-2002]
This sample application demonstrates how a Java program can invoke a method on an Oracle9i object type, where the method is implemented as a Java stored procedure.
Download Now (JAR, 130KB)
Readme
Source

Java Stored Procedure Accessing SQL Object Body [01-Oct-2002]
This sample application demonstrates how to access definition of an Object Type method, which has been implemented as a Java Stored Procedure in the body of the object type.
Download Now (JAR, 149KB)
Readme
Source

Integrated Java Stored Procedure Sample [01-Oct-2002]
This sample application demonstrates an integrated hotel reservation and enquiry application that uses Java Stored Procedures in a number of ways to implement business logic. Java Stored Procedures, Functions and Triggers are used as part of this application. Further Java Stored Procedures that call PLSQL procedures, and also Java Stored Procedure calls from an anonymous PLSQL block is illustrated. The application has a number of components. These components each illustrate different aspects of Java Stored Procedures.
Download Now (JAR, 175KB)
Readme
Source

Accessing Java Stored Procedures using OCI [01-Oct-2002]
This sample application demonstrates how to access a Java Stored Procedure from a C program using Oracle Call Interface(OCI).
Download Now (ZIP, 15KB)
Readme
Source

Accessing Java Stored Procedures using Pro*C [01-Oct-2002]
This sample application demonstrates how to access Java Stored Procedure from a Pro*C program.
Download Now (ZIP, 13KB)
Readme
Source