My Oracle Support Banner

Create Editionable Trigger Cannot Execute via SQL*Plus 11.2 in 12C Database. (Doc ID 2545144.1)

Last updated on JANUARY 30, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

CREATE EDITIONABLE TRIGGER cannot execute via SQL*Plus 11.2

$ sqlplus <USERNAME>/<PASSWORD>@<DATABASE 12c>

SQL*Plus: Release 11.2.0.4.0 Production on Wed May 22 16:37:11 2019
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> CREATE OR REPLACE EDITIONABLE TRIGGER testtrg
  2    before insert on testu.tbl1
  3    for each row
  4  begin
  5   select testu.seq1.nextval into :new.c1 from dual;

Warning: Trigger created with compilation errors.

SQL> end;
SP2-0042: unknown command "end" - rest of line ignored.
SQL> /

Warning: Trigger created with compilation errors.

SQL>

 



Changes

 Connect to database 12c from SQL*Plus 11.2

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.