Home » Oracle FAQ Knowledge Base » Server Options » JServer

What is a Java Stored Procedure/ Trigger?

Submitted by admin on Sat, 2005-11-26 02:46.

A Java Stored Procedure is a procedure coded in Java (as opposed to PL/SQL) and stored in the Oracle database. Java Stored procedures are executed by the database JVM in database memory space.

Java Stored Procedures can be developed in JDBC or SQLJ. Interfacing between PL/SQL and Java are extremely easy. Please note that Java Stored procedures are by default executed with invokers rights. PL/SQL procedures are by default executed with defines rights.

Note: JSP is Java Server Pages and NOT Java Stored Procedures.

    ‹ Why does one need to publish Java in the database?upHow does one write a Java Stored Procedure? ›
    »

    doubt in java triggers for oracle

    Submitted by Praveen (not verified) on Wed, 2006-08-23 00:17.

    I have a certain Java method in my application which I want to be executed everytime a new record is added to a certain table.
    In Oracle I could use a trigger on insert but what can I do if I want a Java method to be executed after a new record was inserted? Does anyone know that?

    »