Error Stored Procedure Error 7853 when firing SQL trigger

lnow

New Member
Hi,
I can create a trigger, but when I run SQL INSERT, which should fire it, I get stored procedure error 7853 (ErrorCode=-20142).
This occurs even if the trigger is empty (is doing nothing).
My code:
Code:
CREATE TRIGGER sUser_trigger
BEFORE INSERT ON sUser
REFERENCING NEWROW
FOR EACH ROW
IMPORT
import java.sql.*;
BEGIN
    NEWROW.setValue(2, 'a');
END;
COMMIT;
 
INSERT INTO sUser (login, salt, password) VALUES ('x', 'y', 'z');

Progress ver. 10.2B.
Could someone help me, please.
 
Top