oracle trigger java,使用oracle的javaJVM，trigger

create or replace java source named FirstClass as

public class FirstClass{

public static String greeting(String name){

return "Hello " + name + "!";

}

}

/

create or replace function firstclass_greeting (name varchar2) return varchar as

language java name 'FirstClass.greeting(java.lang.String) return java.lang.String';

/

SQL> select firstclass_greeting('Bruce') from dual;

FIRSTCLASS_GREETING('BRUCE')

--------------------------------------------------------------------------------

Hello Bruce!

========================================

Listing 4. The Source Code for create_bookstore_tables.sql

drop table books

/

drop table publisher_supply_orders

/

create table books(

book_id number primary key,

publisher_id number,

page_count number,

author_name varchar2(50),

book_title varchar2(50),

description varchar2(500),

status varchar2(10),

inventory_qty number

)

/

insert into books values(100, 200, 234, 'Bruce Hopkins', 'Bluetooth for Java', 'great book', 'IN STOCK', 10);

insert into books values(101, 200, 401, 'Sam Jones', 'Living on the East Coast', 'worth every penny', 'IN STOCK', 50);

insert into books values(102, 250, 278, 'Max Jason', 'The South of France', 'a best-seller', 'IN STOCK', 20);

create table publisher_supply_orders(

book_id number,

publisher_id number,

order_quantity number

)

/

=================

create or replace java source named "ReorderTrigger" as

import java.sql.*;

import oracle.jdbc.driver.*;

public class ReorderTrigger {

public static int REORDER_THRESHOLD = 5;

public static int REORDER_QTY = 25;

public static void reorderBooks(Integer bookID, Integer publi