CODEWITHSUNDEEP
oracle-databasetriggers
Shanna
Shanna

Reputation: 783

Error in creating triggers

I have created a trigger like below. But it shows me a error. 

 2/30    PLS-00103: Encountered the symbol "=" when expecting one of the following:
          := ; not null default character

Can anyone help me solving this? Thanks in advance

CREATE OR REPLACE TRIGGER ADRAKLIVE.TRG_HELPDESK
AFTER UPDATE
OF STATUS
ON ADRAKLIVE.TBL_SERVICEREPORT 
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
     declare ts varchar2(10) = :'YES';
 UPDATE tbl_ithelpdesk
       SET it_closed  =: ts
     WHERE call_no = :NEW.call_no;
END;

Upvotes: 2

Views: 71

Answers (2)

DazzaL
DazzaL

Reputation: 21973

your trigger is malformed:

CREATE OR REPLACE TRIGGER TRG_HELPDESK
AFTER UPDATE
OF STATUS
ON TBL_SERVICEREPORT 
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
declare
  ts varchar2(10) := 'YES';
BEGIN
 UPDATE tbl_ithelpdesk
       SET it_closed  = ts
     WHERE call_no = :NEW.call_no;
END;
/

Upvotes: 2

Pablo Santa Cruz
Pablo Santa Cruz

Reputation: 181270

Change your trigger to:

CREATE OR REPLACE TRIGGER ADRAKLIVE.TRG_HELPDESK
AFTER UPDATE
OF STATUS
ON ADRAKLIVE.TBL_SERVICEREPORT 
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
   ts varchar2(10);
BEGIN
 ts := 'YES';
 UPDATE tbl_ithelpdesk
       SET it_closed  =: ts
     WHERE call_no = :NEW.call_no;
END;

Upvotes: 1

Related Questions