I am using the version of DbVisualizer Pro 9.5.6 and I am running the following sql command to create triggers .
CREATE OR REPLACE TRIGGER "MYDB"."TG_T01_01" BEFORE INSERT ON T01
FOR EACH ROW
BEGIN
:NEW.FECALT_01 := SYSDATE;
:NEW.FECMOD_01 := SYSDATE;
SELECT T01Q00.NEXTVAL INTO :NEW.ID_01 FROM DUAL;
END;
/
CREATE OR REPLACE TRIGGER "MYDB"."TG_T01_02"
BEFORE UPDATE ON T01
FOR EACH ROW
BEGIN
:NEW.FECMOD_01 := SYSDATE;
END;
/...
They are a series of triggers identical of the different tables of the BBDD. When I execute the sql command it shows me these error messages:
14:42:07 [CREATE - 0 rows, 0.032 secs] Command processed. No rows were affected
14:42:07 [: NEW.USUMOD_01 - 0 rows, 0.000 secs] [Code: 17439, SQL State: 99999] Invalid SQL type: sqlKind = UNINITIALIZED
14:42:07 [END - 0 rows, 0.000 secs] [Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
14:42:07 [/ - 0 rows, 0.000 secs] [Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
14:42:07 [: NEW.FECMOD_01 - 0 rows, 0.000 secs] [Code: 17439, SQL State: 99999] Invalid SQL type: sqlKind = UNINITIALIZED
14:42:07 [: NEW.USUALT_01 - 0 rows, 0.000 secs] [Code: 17439, SQL State: 99999] Invalid SQL type: sqlKind = UNINITIALIZED
14:42:07 [: NEW.USUMOD_01 - 0 rows, 0.000 secs] [Code: 17439, SQL State: 99999] Invalid SQL type: sqlKind = UNINITIALIZED
14:42:07 [SELECT - 0 rows, 0.000 secs] [Code: 1008, SQL State: 72000] ORA-01008: not all variables have been linked
14:42:07 [END - 0 rows, 0.015 secs] [Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
...
After this a trigger is created in the following way:
CREATE OR REPLACE TRIGGER "MYDB"."TG_T01_01" BEFORE INSERT ON T01
FOR EACH ROW
BEGIN
:NEW.FECALT_01 := SYSDATE
Note: The trigger that was created in the wrong way can be edited and put the code, so that trigger if it works and the code is well written, as well I have concluded that the most likely interpretation is that sql of DbVisualizer consider the ; as a END .