Create a trigger to report the loss of the IN or OUT parameter: 1 IN the index.

Create a trigger and report that the IN or OUT parameters are lost IN the index: 1. Use the "Oracle Enterprise Manager Console" trigger editor to report "lost IN or OUT parameters IN the index :: 1 "error. The specific SQL statement is: [SQL] CREATE OR REPLACE TRIGGER "MYDB ". "AA_TEST" before insert on "AA_TEST" for each row declare num NUMBER (10): = 0; BEGIN www.2cto.com select count (*) INTO num FROM AA_TEST WHERE ST_NAME =: NEW. ST_NAME; END; The above error is reported as long as the trigger body contains the NEW keyword. You can use "SQL * Plus Worksheet" to create a trigger. It seems that the "Oracle Enterprise Manager Console" trigger editor has a bug. Version: 10.2.0.0.0 official version. From the wayz11 Column