Skip to content

TGSqlParser.parse can not parse trigger when use syntax :NEW and :OLD #19

Open
@1987jy

Description

@1987jy

TGSqlParser.parse can not parse trigger when use syntax :NEW and :OLD

this is oracle help doc about :NEW and :OLD
https://docs.oracle.com/database/121/TDDDG/tdddg_triggers.htm#TDDDG52800

CREATE OR REPLACE TRIGGER update_name_view_trigger
INSTEAD OF UPDATE ON emp_locations
BEGIN
UPDATE employees SET
first_name = substr( :NEW.name, instr( :new.name, ',' )+2),
last_name = substr( :NEW.name, 1, instr( :new.name, ',')-1)
WHERE employee_id = :OLD.employee_id;
END;

TGSqlParser.parse return Error when tokenlize when parse :NEW and :OLD

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions