I am use oracle 10g and jdk 1.6
I want to call java class from oracle Trigger for that I am tries below-
My java class is-
public class DBTrigger
{
public static void logSal()
{
System.out.println("In java class");
}
}
and my oracle trigger is-
CREATE OR REPLACE TRIGGER sal_trig
AFTER UPDATE OF sal ON emp
FOR EACH ROW
WHEN (new.sal > 1.2 * old.sal)
CALL logSal();
but I am able to call it.
so please give me a suggestion.
What the link say is
1) create the Java class
CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED My_JavaClass AS
import java.io.*;
public class DBTrigger
{
public static void logSal()
{
System.out.println("In java class");
}
}
/
2) Create a stored procedure (a place holder basically) to call your java class
CREATE OR REPLACE PROCEDURE My_Javaclass_proc
AS LANGUAGE JAVA NAME 'DBTrigger.logSal()';
/
3) Create the trigger and call this procedure
CREATE OR REPLACE TRIGGER sal_trig
AFTER UPDATE OF sal ON emp
FOR EACH ROW
WHEN (new.sal > 1.2 * old.sal)
begin
My_Javaclass_proc;
end;
/
Try to do using above steps and share the results.
As mentioned in the oracle docs Calling Java from Database Triggers ,You have to publish your Java method as procedure and have to call that procedure in the trigger.
Have a look at the example in the above link or other example here
