Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE RESERVATION (
    numc number(10, 0),
    numr number(10, 0)
);
CREATE TABLE CLIENTS (
    numc  number(10, 0),
    nb_reserv number(10, 0),
    solde  number(10, 0)    
)
CREATE OR REPLACE TRIGGER tr_update_solde_nbreserv
AFTER INSERT ON RESERVATION
FOR EACH ROW
BEGIN
    UPDATE CLIENTS
    SET CLIENTS.NB_RESERV = NB_RESERV+1 , CLIENTS.SOLDE = SOLDE+1
    FROM dbo.clients as c
    INNER JOIN dbo.reservation as r ON c.numc = r.numc
    WHERE r.numr = :new.numr;
        
    BEGIN
        SELECT fillHist_station FROM DUAL;
    END;
        
END tr_update_solde_nbreserv;
/
ORA-24344: success with compilation error

select * from SYS.USER_ERRORS where NAME = UPPER('tr_update_solde_nbreserv');


NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
ATTRIBUTE
MESSAGE_NUMBER


TR_UPDATE_SOLDE_NBRESERV
TRIGGER
1
4
5
PL/SQL: ORA-00933: SQL command not properly ended
ERROR
0

TR_UPDATE_SOLDE_NBRESERV
TRIGGER
2
2
5
PL/SQL: SQL Statement ignored
ERROR
0


CREATE OR REPLACE TRIGGER tr_update_solde_nbreserv
AFTER INSERT ON RESERVATION
FOR EACH ROW
BEGIN
    UPDATE CLIENTS
    SET NB_RESERV = NB_RESERV+1 , SOLDE = SOLDE+1
    WHERE numc = :new.numc;
END tr_update_solde_nbreserv;
/
select * from SYS.USER_ERRORS where NAME = UPPER('tr_update_solde_nbreserv');
insert into CLIENTS VALUES (1, 0, 0);
1 rows affected

insert into RESERVATION VALUES(1, 1);
1 rows affected

SELECT * FROM CLIENTS;


NUMC
NB_RESERV
SOLDE


1
1
1

NAME	TYPE	SEQUENCE	LINE	POSITION	TEXT	ATTRIBUTE	MESSAGE_NUMBER
TR_UPDATE_SOLDE_NBRESERV	TRIGGER	1	4	5	PL/SQL: ORA-00933: SQL command not properly ended	ERROR	0
TR_UPDATE_SOLDE_NBRESERV	TRIGGER	2	2	5	PL/SQL: SQL Statement ignored	ERROR	0