Java中的SQL触发器调用函数

Question

你好，我的毕业论文有个问题。我应该在Orale上编写一个触发器，它应该执行一个java函数，但问题是：

create or replace function callTokengenerator
return boolean
as language java
NAME 'SqlStatements.setTrigger()
     return java.lang.Boolean';


create or replace PROCEDURE generateTokens
is
begin
    callTokengenerator;
end;


CREATE OR REPLACE TRIGGER tokengenerator AFTER UPDATE OF ACTIVE ON COURSE Declare
    run boolean := generateTokens;
BEGIN
    run;
END;

这是我产生的错误

Error Message

Answer 1

"RUN“不是有效的Oracle命令。触发器必须直接调用函数。有关正确的触发器语法和结构，请参阅此处：https://docs.oracle.com/en/database/oracle/oracle-database/19/jjdev/calling-Java-from-database-triggers.html#GUID-5C498DEF-0348-484D-AA26-2A88EF348D5C

试试这个：

create or replace function callTokengenerator
return boolean
as language java
NAME 'SqlStatements.setTrigger()
     return java.lang.Boolean';

CREATE OR REPLACE TRIGGER tokengenerator AFTER UPDATE OF ACTIVE ON COURSE 
DECLARE
    run boolean;
BEGIN
    run := callTokengenerator;
END;