Error using trigger in Oracle sql

Question

CREATE OR REPLACE TRIGGER bi_payregister
  BEFORE INSERT
  ON payregister
  FOR EACH ROW
BEGIN
  SELECT helloabc.NEXTVAL INTO :new.id FROM DUAL;
END

what is wrong with this statement, it shows error.I have created PAYREGISTER table and HelloABC sequence already.

Error(2,58): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ; <an identifier> <a double-quoted delimited-identifier> The symbol ";" was substituted for "end-of-file" to continue. — Aamir
– Aamir, Commented Mar 31, 2015 at 14:30

Boneist · Accepted Answer · 2015-03-31 14:33:53Z

2

Assuming you're talking about the syntax error that your code produces, you're missing the semi-colon (and forward slash) off the end of the "END". It should be:

CREATE OR REPLACE TRIGGER bi_payregister
  BEFORE INSERT
  ON payregister
  FOR EACH ROW
BEGIN
  SELECT helloabc.NEXTVAL INTO :new.id FROM DUAL;
END;
/

answered Mar 31, 2015 at 14:33

Boneist

23.6k1 gold badge28 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error using trigger in Oracle sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related