Home -->

 

Technical Documents

 - Java Caps (JCAPs)

    - Architecture

    - Domain vs. Logical Host

    - Web Services

    - JCD vs. BPEL

    - Scalability

    - JVM

 - Java

    - JDBC Stored Proc Calls

 - Oracle

    - HS Connectivity Setup

    - Orakill

    - PL/SQL and JSP

    - Queues

Applications

Links

 - Webservices (Axis)

 - PSOUG (Oracle)

 - JCAPs Forum

 

Blog

 - Enter Blog

 

Have a topic I may know about?  Email me

 

 

Executing JSP code through PL/SQL

 

Steps to create or add JSP to Oracle.

Step 1:
Create Java class or jar. Test and compile outside of Oracle.

Step 2:
Run -
loadjava -user sys/<pw>@<sid> -verbose -resolve -synonym <class/jar>

Step 3:
Create a java package representing your java class

CREATE OR REPLACE PACKAGE Email AS
PROCEDURE <PROCEDURE NAME> (Param1 VARCHAR2, Param2 VARCHAR2, Param3 VARCHAR2, Param4 VARCHAR2, Param5 VARCHAR2)
AS
LANGUAGE JAVA
NAME '<CLASS>.<METHOD>(java.lang.String, java.lang.String, java.lang.String,java.lang.String, java.lang.String)'; END;

Step 4:
Execute JSP via the package created in Step 3


Notes:
-All Java code to be reference in Oracle must be "PUBLIC STATIC VOID"
-All Java classes currently reside under SYS user -Packages can be created from within TOAD automatically from existing Java classes/jars -Users using JSP must have Java priveleges (I still have a question out to Oracle as to what the exact priveleges should be)