Bad bind variable error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • yasir saleem
    New Member
    • May 2019
    • 1

    Bad bind variable error

    Code:
    CREATE OR REPLACE TRIGGER display_salary_changes
    BEFORE UPDATE ON customers
    FOR EACH ROW
    WHEN (NEW.ID > 0)
    DECLARE
    sal_diff number;
    BEGIN
    sal_diff:=:NEW.SALARY-:OLD.SALARY;
    dbms_output.put_line('Old salary: ' || :OLD.SALARY);
    dbms_output.put_line('New salary: ' || :NEW.SALARY);
    dbms_output.put_line('Salary difference: ' || sal_diff);
    END;
    Last edited by gits; May 10 '19, 11:22 AM. Reason: added code tags
Working...