Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PLS-00103: trigger creating error?

Erhan_torontoSep 9 2013 — edited Sep 9 2013

Oracle 11gR2

--------------------------------------------

Why I am getting below error when I try to create below trigger?

CREATE TRIGGER log_errors AFTER SERVERERROR ON DATABASE

   BEGIN

      IF (IS_SERVERERROR (1017)) THEN

         <special processing of logon error>

      ELSE

         <log error number>

      END IF;

   END;

/

       PLS-00103: Encountered the symbol "<" when expecting one of the following:

          ( begin case declare exit for goto if loop mod null pragma

          raise return select update while with <an identifier>

          <a double-quoted delimited-identifier> <a bind variable> <<

          continue close current delete fetch lock insert open rollback

          savepoint set sql execute commit forall merge pipe purge

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2013
Added on Sep 9 2013
4 comments
602 views