CREATE OR REPLACE TRIGGER "BILLING_SCHEMA"."SUMMARY_DETAIL" BEFORE INSERT ON SCHEMA.SUMMARY_DETAIL FOR EACH ROW
BEGIN SELECT SCHEMA.SEQ_IMPORT_SUMMARY_DETAIL.NEXTVAL INTO :NEW.ID FROM DUAL; END;
slash as the terminator because of an already existing semicolon in the trigger statement.
Could you please help me with a way to standardize the statement terminator to a slash.
Thanks in advance,
Edited by: user5417526 on 11/02/2013 16:43