plsql - Sequence and Trigger PL/SQL script for Automatic ID generation on a table -
can me fix code. doesn´t run on pl/sql (sqlplus @script.sql), giving sp2-0552: bind variable "new" not declared. script.sql prompt creating table systemdatalog; declare counter1 integer; counter2 integer; begin select count(*) counter1 all_tables table_name='systemdatalog' , owner='mzmesdb'; if counter1 = 1 drop table systemdatalog; end if; select count(*) counter2 all_sequences sequence name='seqsystemdatalog'; if counter2 = 1 drop sequence seqsystemdatalogid; endif; create table "mzmesdb"."systemdatalog" ( "id" integer not null , "datetime" date not null , "type" varchar2(64) not null, "severity" integer not null, "source" varchar2(64) not null, "user" varchar2(64) not null,