Create Editionable Trigger Cannot Execute via SQL*Plus 11.2 in 12C Database.
(Doc ID 2545144.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation 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>
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 |