发生PL / SQL语句被忽略的错误

| 在下面的代码PL / SQL语句中忽略错误发生错误,错误行以粗体和斜体显示
create or replace
TRIGGER TRGBILLINGADDRESS 
AFTER UPDATE ON TBLMACCOUNTADDRESS 
FOR EACH ROW
DECLARE
    add1 VARCHAR2(100);
    add2 VARCHAR2(100);
    cityid VARCHAR2(75);
    stateid VARCHAR2(75);
    pincd VARCHAR2(10);
BEGIN

   SELECT address1,address2,city_id,state_id,pincode 
   INTO add1,add2,cityid,stateid,pincd  FROM wom.tbltaddress ta  WHERE ta.ID IN (
          SELECT vbac.billing_address_id
          FROM wom.vw_billaddresschange vbac, wom.tbltaddress ita
          WHERE vbac.billing_address_id = ita.ID
          AND vbac.lcid = parlcid);
   ***IF add1 = :NEW.address1 AND add2 = :NEW.address2 AND  cityid = :NEW.cityid AND  stateid = :NEW.stateid AND  pincode = :NEW.zip THEN***            
          dbms_output.put_line(\'Address Already Exist in tbltaddress table\');
   ELSE
          UPDATE wom.tbltaddress ta
                   SET ta.address1 = :NEW.address1,
                       ta.address2 = :NEW.address2,
                      ***ta.city_id = :NEW.cityid*,**
                       ta.country_id = \'CTR0001\',
                       ta.state_id = :NEW.stateid,
                       ta.pincode = :NEW.zip
                 WHERE ta.ID IN (
                          SELECT vbac.billing_address_id
                            FROM wom.vw_billaddresschange vbac, wom.tbltaddress ita
                           WHERE vbac.billing_address_id = ita.ID
                                 AND vbac.lcid = parlcid);
   END IF;
END;
已邀请:
您的变量声明为
pincd
,而不是
pincode
。 ѭ2是表中的字段。

要回复问题请先登录注册