executing Java code from database trigger.

--0016e6505a0e1dc92b04ae7267bc
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I wanted to run java method from trigger. for that i need to write java db
procedure.. as mention in
http://download.oracle.com/javase/tutorial/jdbc/basics/storedprocedures.html#creating_stored_procedures_java_db
but i am getting sql syntax error at 'AS LANGUAGE' please let me know if you
have th solution for  the same..

my create procedure statement is =

          "CREATE PROCEDURE log_sal(IN idsal float, IN old_sal float, IN
new_sal float) " +
            //"PARAMETER STYLE JAVA " +
          "AS "+
            "LANGUAGE JAVA " +
            //"DYNAMIC RESULT SETS 1 " +
            "EXTERNAL NAME 'com.trigger.DBTrigger.logSal'";

--0016e6505a0e1dc92b04ae7267bc--