Apache ZooKeeper WEB-UI(Apache ZooKeeper WEB-UI)

 您不需要在SALESTRANSACTION的行触发器中查询SALESTRANSACTION - 您应该使用调用触发器的SALESTRANSACTION行上的：NEW值。 我建议你重写你的触发器： 
 
create table excellentsales
(EXCELLENTSALES_ID  NUMBER
   CONSTRAINT PK_EXCELLENTSALES
   PRIMARY KEY
     USING INDEX,
agentid varchar2(5) not null,
agentname varchar2(25),
carmodel varchar2(25),
mfname varchar2(25))

CREATE SEQUENCE EXCELLENTSALES_SEQ
  START WITH 1
  INCREMENT BY 1;

create or replace trigger filltable
  after insert on salestransaction
  for each row
declare
  aname varchar2(25);
  modname varchar2(25);
  manfname varchar2(25);
  askpr number;
  agrpr number;
begin    
  SELECT m.NAME, mf.NAME, c.ASKINGPRICE
    INTO modname, manfname, askpr
    FROM CAR c
    INNER JOIN MODEL m
      ON m.MODELNO = c.MODELNO
    INNER JOIN MANUFACTURER mf
      ON mf.MANUFACTURERID = m.MANUFACTURERID
    WHERE c.VIN = :NEW.VIN;

  SELECT sa.NAME
    INTO aname
    FROM SALESAGENT sa
    WHERE sa.AGENTID = :NEW.AGENTID;

  agrpr := :NEW.AGREEDPRICE;

  if agrpr > askpr * 1.2 then
    insert into excellentsales (EXCELLENTSALES_ID, AGENTID, AGENTNAME, CARMODEL, MFNAME)
      values(EXCELLENTSALES_SEQ.nextval, :NEW.AGENTID, aname, modname, manfname);
  end if;
end filltable;
 
 我还重新设计了您的EXCELLENTSALES表，以包含一个不是AGENTID的主键。 最初设计的EXCELLENTSALES没有记录实际的AGENTID（显然应该来自SALESTRANSACTION），在现实世界中可能需要，例如，支付佣金。 

You don't need to query SALESTRANSACTION within a row trigger on SALESTRANSACTION - you should instead be using the :NEW values on the SALESTRANSACTION row for which the trigger was invoked. I suggest rewriting your trigger as:
 
create table excellentsales
(EXCELLENTSALES_ID  NUMBER
   CONSTRAINT PK_EXCELLENTSALES
   PRIMARY KEY
     USING INDEX,
agentid varchar2(5) not null,
agentname varchar2(25),
carmodel varchar2(25),
mfname varchar2(25))

CREATE SEQUENCE EXCELLENTSALES_SEQ
  START WITH 1
  INCREMENT BY 1;

create or replace trigger filltable
  after insert on salestransaction
  for each row
declare
  aname varchar2(25);
  modname varchar2(25);
  manfname varchar2(25);
  askpr number;
  agrpr number;
begin    
  SELECT m.NAME, mf.NAME, c.ASKINGPRICE
    INTO modname, manfname, askpr
    FROM CAR c
    INNER JOIN MODEL m
      ON m.MODELNO = c.MODELNO
    INNER JOIN MANUFACTURER mf
      ON mf.MANUFACTURERID = m.MANUFACTURERID
    WHERE c.VIN = :NEW.VIN;

  SELECT sa.NAME
    INTO aname
    FROM SALESAGENT sa
    WHERE sa.AGENTID = :NEW.AGENTID;

  agrpr := :NEW.AGREEDPRICE;

  if agrpr > askpr * 1.2 then
    insert into excellentsales (EXCELLENTSALES_ID, AGENTID, AGENTNAME, CARMODEL, MFNAME)
      values(EXCELLENTSALES_SEQ.nextval, :NEW.AGENTID, aname, modname, manfname);
  end if;
end filltable;
 
I also redesigned your EXCELLENTSALES table to include a primary key which is not the AGENTID. As originally designed EXCELLENTSALES did not record the actual AGENTID (which should apparently be coming from SALESTRANSACTION), which in the real world might be needed, for example, for paying commissions.