set sql_mode=oracle;
create or replace table t2 (name varchar(30),result varchar(2));
delimiter /
create procedure f1 as ACCESSIBLE integer;begin null; end;
/
insert into t2 values ('ACCESSIBLE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ACCESSIBLE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ACTION integer;begin null; end;
/
insert into t2 values ('ACTION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ACTION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ADD integer;begin null; end;
/
insert into t2 values ('ADD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ADD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ADMIN integer;begin null; end;
/
insert into t2 values ('ADMIN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ADMIN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as AFTER integer;begin null; end;
/
insert into t2 values ('AFTER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='AFTER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as AGAINST integer;begin null; end;
/
insert into t2 values ('AGAINST','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='AGAINST'
/
commit
/
drop procedure f1
/ 
create procedure f1 as AGGREGATE integer;begin null; end;
/
insert into t2 values ('AGGREGATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='AGGREGATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ALL integer;begin null; end;
/
insert into t2 values ('ALL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ALL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ALGORITHM integer;begin null; end;
/
insert into t2 values ('ALGORITHM','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ALGORITHM'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ALTER integer;begin null; end;
/
insert into t2 values ('ALTER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ALTER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ALWAYS integer;begin null; end;
/
insert into t2 values ('ALWAYS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ALWAYS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ANALYZE integer;begin null; end;
/
insert into t2 values ('ANALYZE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ANALYZE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as AND integer;begin null; end;
/
insert into t2 values ('AND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='AND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ANY integer;begin null; end;
/
insert into t2 values ('ANY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ANY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as AS integer;begin null; end;
/
insert into t2 values ('AS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='AS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ASC integer;begin null; end;
/
insert into t2 values ('ASC','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ASC'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ASCII integer;begin null; end;
/
insert into t2 values ('ASCII','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ASCII'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ASENSITIVE integer;begin null; end;
/
insert into t2 values ('ASENSITIVE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ASENSITIVE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as AT integer;begin null; end;
/
insert into t2 values ('AT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='AT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ATOMIC integer;begin null; end;
/
insert into t2 values ('ATOMIC','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ATOMIC'
/
commit
/
drop procedure f1
/ 
create procedure f1 as AUTHORS integer;begin null; end;
/
insert into t2 values ('AUTHORS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='AUTHORS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as AUTO_INCREMENT integer;begin null; end;
/
insert into t2 values ('AUTO_INCREMENT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='AUTO_INCREMENT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as AUTOEXTEND_SIZE integer;begin null; end;
/
insert into t2 values ('AUTOEXTEND_SIZE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='AUTOEXTEND_SIZE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as AUTO integer;begin null; end;
/
insert into t2 values ('AUTO','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='AUTO'
/
commit
/
drop procedure f1
/ 
create procedure f1 as AVG integer;begin null; end;
/
insert into t2 values ('AVG','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='AVG'
/
commit
/
drop procedure f1
/ 
create procedure f1 as AVG_ROW_LENGTH integer;begin null; end;
/
insert into t2 values ('AVG_ROW_LENGTH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='AVG_ROW_LENGTH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BACKUP integer;begin null; end;
/
insert into t2 values ('BACKUP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BACKUP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BEFORE integer;begin null; end;
/
insert into t2 values ('BEFORE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BEFORE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BEGIN integer;begin null; end;
/
insert into t2 values ('BEGIN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BEGIN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BETWEEN integer;begin null; end;
/
insert into t2 values ('BETWEEN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BETWEEN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BIGINT integer;begin null; end;
/
insert into t2 values ('BIGINT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BIGINT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BINARY integer;begin null; end;
/
insert into t2 values ('BINARY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BINARY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BINLOG integer;begin null; end;
/
insert into t2 values ('BINLOG','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BINLOG'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BIT integer;begin null; end;
/
insert into t2 values ('BIT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BIT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BLOB integer;begin null; end;
/
insert into t2 values ('BLOB','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BLOB'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BLOCK integer;begin null; end;
/
insert into t2 values ('BLOCK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BLOCK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BODY integer;begin null; end;
/
insert into t2 values ('BODY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BODY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BOOL integer;begin null; end;
/
insert into t2 values ('BOOL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BOOL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BOOLEAN integer;begin null; end;
/
insert into t2 values ('BOOLEAN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BOOLEAN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BOTH integer;begin null; end;
/
insert into t2 values ('BOTH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BOTH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BTREE integer;begin null; end;
/
insert into t2 values ('BTREE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BTREE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BY integer;begin null; end;
/
insert into t2 values ('BY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BYTE integer;begin null; end;
/
insert into t2 values ('BYTE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BYTE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CACHE integer;begin null; end;
/
insert into t2 values ('CACHE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CACHE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CALL integer;begin null; end;
/
insert into t2 values ('CALL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CALL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CASCADE integer;begin null; end;
/
insert into t2 values ('CASCADE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CASCADE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CASCADED integer;begin null; end;
/
insert into t2 values ('CASCADED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CASCADED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CASE integer;begin null; end;
/
insert into t2 values ('CASE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CASE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CATALOG_NAME integer;begin null; end;
/
insert into t2 values ('CATALOG_NAME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CATALOG_NAME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CHAIN integer;begin null; end;
/
insert into t2 values ('CHAIN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CHAIN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CHANGE integer;begin null; end;
/
insert into t2 values ('CHANGE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CHANGE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CHANGED integer;begin null; end;
/
insert into t2 values ('CHANGED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CHANGED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CHAR integer;begin null; end;
/
insert into t2 values ('CHAR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CHAR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CHARACTER integer;begin null; end;
/
insert into t2 values ('CHARACTER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CHARACTER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CHARSET integer;begin null; end;
/
insert into t2 values ('CHARSET','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CHARSET'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CHECK integer;begin null; end;
/
insert into t2 values ('CHECK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CHECK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CHECKPOINT integer;begin null; end;
/
insert into t2 values ('CHECKPOINT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CHECKPOINT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CHECKSUM integer;begin null; end;
/
insert into t2 values ('CHECKSUM','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CHECKSUM'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CIPHER integer;begin null; end;
/
insert into t2 values ('CIPHER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CIPHER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CLASS_ORIGIN integer;begin null; end;
/
insert into t2 values ('CLASS_ORIGIN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CLASS_ORIGIN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CLIENT integer;begin null; end;
/
insert into t2 values ('CLIENT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CLIENT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CLOB integer;begin null; end;
/
insert into t2 values ('CLOB','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CLOB'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CLOSE integer;begin null; end;
/
insert into t2 values ('CLOSE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CLOSE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COALESCE integer;begin null; end;
/
insert into t2 values ('COALESCE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COALESCE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CODE integer;begin null; end;
/
insert into t2 values ('CODE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CODE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COLLATE integer;begin null; end;
/
insert into t2 values ('COLLATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COLLATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COLLATION integer;begin null; end;
/
insert into t2 values ('COLLATION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COLLATION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COLUMN integer;begin null; end;
/
insert into t2 values ('COLUMN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COLUMN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COLUMN_NAME integer;begin null; end;
/
insert into t2 values ('COLUMN_NAME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COLUMN_NAME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COLUMNS integer;begin null; end;
/
insert into t2 values ('COLUMNS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COLUMNS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COLUMN_ADD integer;begin null; end;
/
insert into t2 values ('COLUMN_ADD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COLUMN_ADD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COLUMN_CHECK integer;begin null; end;
/
insert into t2 values ('COLUMN_CHECK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COLUMN_CHECK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COLUMN_CREATE integer;begin null; end;
/
insert into t2 values ('COLUMN_CREATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COLUMN_CREATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COLUMN_DELETE integer;begin null; end;
/
insert into t2 values ('COLUMN_DELETE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COLUMN_DELETE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COLUMN_GET integer;begin null; end;
/
insert into t2 values ('COLUMN_GET','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COLUMN_GET'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COMMENT integer;begin null; end;
/
insert into t2 values ('COMMENT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COMMENT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COMMIT integer;begin null; end;
/
insert into t2 values ('COMMIT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COMMIT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COMMITTED integer;begin null; end;
/
insert into t2 values ('COMMITTED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COMMITTED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COMPACT integer;begin null; end;
/
insert into t2 values ('COMPACT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COMPACT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COMPLETION integer;begin null; end;
/
insert into t2 values ('COMPLETION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COMPLETION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COMPRESSED integer;begin null; end;
/
insert into t2 values ('COMPRESSED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COMPRESSED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONCURRENT integer;begin null; end;
/
insert into t2 values ('CONCURRENT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONCURRENT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONDITION integer;begin null; end;
/
insert into t2 values ('CONDITION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONDITION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONNECTION integer;begin null; end;
/
insert into t2 values ('CONNECTION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONNECTION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONSISTENT integer;begin null; end;
/
insert into t2 values ('CONSISTENT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONSISTENT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONSTRAINT integer;begin null; end;
/
insert into t2 values ('CONSTRAINT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONSTRAINT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONSTRAINT_CATALOG integer;begin null; end;
/
insert into t2 values ('CONSTRAINT_CATALOG','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONSTRAINT_CATALOG'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONSTRAINT_NAME integer;begin null; end;
/
insert into t2 values ('CONSTRAINT_NAME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONSTRAINT_NAME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONSTRAINT_SCHEMA integer;begin null; end;
/
insert into t2 values ('CONSTRAINT_SCHEMA','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONSTRAINT_SCHEMA'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONTAINS integer;begin null; end;
/
insert into t2 values ('CONTAINS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONTAINS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONTEXT integer;begin null; end;
/
insert into t2 values ('CONTEXT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONTEXT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONTINUE integer;begin null; end;
/
insert into t2 values ('CONTINUE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONTINUE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONTRIBUTORS integer;begin null; end;
/
insert into t2 values ('CONTRIBUTORS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONTRIBUTORS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CONVERT integer;begin null; end;
/
insert into t2 values ('CONVERT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CONVERT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CPU integer;begin null; end;
/
insert into t2 values ('CPU','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CPU'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CREATE integer;begin null; end;
/
insert into t2 values ('CREATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CREATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CROSS integer;begin null; end;
/
insert into t2 values ('CROSS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CROSS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CUBE integer;begin null; end;
/
insert into t2 values ('CUBE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CUBE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CURRENT integer;begin null; end;
/
insert into t2 values ('CURRENT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CURRENT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CURRENT_DATE integer;begin null; end;
/
insert into t2 values ('CURRENT_DATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CURRENT_DATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CURRENT_POS integer;begin null; end;
/
insert into t2 values ('CURRENT_POS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CURRENT_POS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CURRENT_ROLE integer;begin null; end;
/
insert into t2 values ('CURRENT_ROLE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CURRENT_ROLE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CURRENT_TIME integer;begin null; end;
/
insert into t2 values ('CURRENT_TIME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CURRENT_TIME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CURRENT_TIMESTAMP integer;begin null; end;
/
insert into t2 values ('CURRENT_TIMESTAMP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CURRENT_TIMESTAMP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CURRENT_USER integer;begin null; end;
/
insert into t2 values ('CURRENT_USER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CURRENT_USER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CURSOR integer;begin null; end;
/
insert into t2 values ('CURSOR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CURSOR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CURSOR_NAME integer;begin null; end;
/
insert into t2 values ('CURSOR_NAME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CURSOR_NAME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DATA integer;begin null; end;
/
insert into t2 values ('DATA','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DATA'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DATABASE integer;begin null; end;
/
insert into t2 values ('DATABASE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DATABASE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DATABASES integer;begin null; end;
/
insert into t2 values ('DATABASES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DATABASES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DATAFILE integer;begin null; end;
/
insert into t2 values ('DATAFILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DATAFILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DATE integer;begin null; end;
/
insert into t2 values ('DATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DATETIME integer;begin null; end;
/
insert into t2 values ('DATETIME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DATETIME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DAY integer;begin null; end;
/
insert into t2 values ('DAY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DAY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DAY_HOUR integer;begin null; end;
/
insert into t2 values ('DAY_HOUR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DAY_HOUR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DAY_MICROSECOND integer;begin null; end;
/
insert into t2 values ('DAY_MICROSECOND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DAY_MICROSECOND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DAY_MINUTE integer;begin null; end;
/
insert into t2 values ('DAY_MINUTE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DAY_MINUTE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DAY_SECOND integer;begin null; end;
/
insert into t2 values ('DAY_SECOND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DAY_SECOND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DEALLOCATE integer;begin null; end;
/
insert into t2 values ('DEALLOCATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DEALLOCATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DEC integer;begin null; end;
/
insert into t2 values ('DEC','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DEC'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DECIMAL integer;begin null; end;
/
insert into t2 values ('DECIMAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DECIMAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DECLARE integer;begin null; end;
/
insert into t2 values ('DECLARE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DECLARE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DEFAULT integer;begin null; end;
/
insert into t2 values ('DEFAULT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DEFAULT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DEFINER integer;begin null; end;
/
insert into t2 values ('DEFINER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DEFINER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DELAYED integer;begin null; end;
/
insert into t2 values ('DELAYED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DELAYED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DELAY_KEY_WRITE integer;begin null; end;
/
insert into t2 values ('DELAY_KEY_WRITE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DELAY_KEY_WRITE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DELETE integer;begin null; end;
/
insert into t2 values ('DELETE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DELETE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DESC integer;begin null; end;
/
insert into t2 values ('DESC','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DESC'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DESCRIBE integer;begin null; end;
/
insert into t2 values ('DESCRIBE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DESCRIBE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DES_KEY_FILE integer;begin null; end;
/
insert into t2 values ('DES_KEY_FILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DES_KEY_FILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DETERMINISTIC integer;begin null; end;
/
insert into t2 values ('DETERMINISTIC','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DETERMINISTIC'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DIAGNOSTICS integer;begin null; end;
/
insert into t2 values ('DIAGNOSTICS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DIAGNOSTICS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DIRECTORY integer;begin null; end;
/
insert into t2 values ('DIRECTORY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DIRECTORY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DISABLE integer;begin null; end;
/
insert into t2 values ('DISABLE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DISABLE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DISCARD integer;begin null; end;
/
insert into t2 values ('DISCARD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DISCARD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DISK integer;begin null; end;
/
insert into t2 values ('DISK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DISK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DISTINCT integer;begin null; end;
/
insert into t2 values ('DISTINCT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DISTINCT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DISTINCTROW integer;begin null; end;
/
insert into t2 values ('DISTINCTROW','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DISTINCTROW'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DIV integer;begin null; end;
/
insert into t2 values ('DIV','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DIV'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DO integer;begin null; end;
/
insert into t2 values ('DO','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DO'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DOUBLE integer;begin null; end;
/
insert into t2 values ('DOUBLE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DOUBLE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DO_DOMAIN_IDS integer;begin null; end;
/
insert into t2 values ('DO_DOMAIN_IDS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DO_DOMAIN_IDS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DROP integer;begin null; end;
/
insert into t2 values ('DROP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DROP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DUAL integer;begin null; end;
/
insert into t2 values ('DUAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DUAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DUMPFILE integer;begin null; end;
/
insert into t2 values ('DUMPFILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DUMPFILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DUPLICATE integer;begin null; end;
/
insert into t2 values ('DUPLICATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DUPLICATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DYNAMIC integer;begin null; end;
/
insert into t2 values ('DYNAMIC','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DYNAMIC'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EACH integer;begin null; end;
/
insert into t2 values ('EACH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EACH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ELSE integer;begin null; end;
/
insert into t2 values ('ELSE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ELSE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ELSEIF integer;begin null; end;
/
insert into t2 values ('ELSEIF','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ELSEIF'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ELSIF integer;begin null; end;
/
insert into t2 values ('ELSIF','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ELSIF'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ENABLE integer;begin null; end;
/
insert into t2 values ('ENABLE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ENABLE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ENCLOSED integer;begin null; end;
/
insert into t2 values ('ENCLOSED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ENCLOSED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as END integer;begin null; end;
/
insert into t2 values ('END','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='END'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ENDS integer;begin null; end;
/
insert into t2 values ('ENDS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ENDS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ENGINE integer;begin null; end;
/
insert into t2 values ('ENGINE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ENGINE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ENGINES integer;begin null; end;
/
insert into t2 values ('ENGINES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ENGINES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ENUM integer;begin null; end;
/
insert into t2 values ('ENUM','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ENUM'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ERROR integer;begin null; end;
/
insert into t2 values ('ERROR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ERROR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ERRORS integer;begin null; end;
/
insert into t2 values ('ERRORS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ERRORS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ESCAPE integer;begin null; end;
/
insert into t2 values ('ESCAPE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ESCAPE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ESCAPED integer;begin null; end;
/
insert into t2 values ('ESCAPED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ESCAPED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EVENT integer;begin null; end;
/
insert into t2 values ('EVENT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EVENT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EVENTS integer;begin null; end;
/
insert into t2 values ('EVENTS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EVENTS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EVERY integer;begin null; end;
/
insert into t2 values ('EVERY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EVERY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXAMINED integer;begin null; end;
/
insert into t2 values ('EXAMINED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXAMINED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXCHANGE integer;begin null; end;
/
insert into t2 values ('EXCHANGE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXCHANGE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXCLUDE integer;begin null; end;
/
insert into t2 values ('EXCLUDE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXCLUDE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXECUTE integer;begin null; end;
/
insert into t2 values ('EXECUTE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXECUTE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXCEPTION integer;begin null; end;
/
insert into t2 values ('EXCEPTION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXCEPTION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXISTS integer;begin null; end;
/
insert into t2 values ('EXISTS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXISTS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXIT integer;begin null; end;
/
insert into t2 values ('EXIT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXIT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXPANSION integer;begin null; end;
/
insert into t2 values ('EXPANSION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXPANSION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXPORT integer;begin null; end;
/
insert into t2 values ('EXPORT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXPORT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXPLAIN integer;begin null; end;
/
insert into t2 values ('EXPLAIN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXPLAIN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXTENDED integer;begin null; end;
/
insert into t2 values ('EXTENDED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXTENDED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXTENT_SIZE integer;begin null; end;
/
insert into t2 values ('EXTENT_SIZE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXTENT_SIZE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FALSE integer;begin null; end;
/
insert into t2 values ('FALSE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FALSE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FAST integer;begin null; end;
/
insert into t2 values ('FAST','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FAST'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FAULTS integer;begin null; end;
/
insert into t2 values ('FAULTS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FAULTS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FETCH integer;begin null; end;
/
insert into t2 values ('FETCH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FETCH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FIELDS integer;begin null; end;
/
insert into t2 values ('FIELDS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FIELDS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FILE integer;begin null; end;
/
insert into t2 values ('FILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FIRST integer;begin null; end;
/
insert into t2 values ('FIRST','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FIRST'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FIXED integer;begin null; end;
/
insert into t2 values ('FIXED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FIXED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FLOAT integer;begin null; end;
/
insert into t2 values ('FLOAT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FLOAT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FLOAT4 integer;begin null; end;
/
insert into t2 values ('FLOAT4','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FLOAT4'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FLOAT8 integer;begin null; end;
/
insert into t2 values ('FLOAT8','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FLOAT8'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FLUSH integer;begin null; end;
/
insert into t2 values ('FLUSH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FLUSH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FOLLOWING integer;begin null; end;
/
insert into t2 values ('FOLLOWING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FOLLOWING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FOLLOWS integer;begin null; end;
/
insert into t2 values ('FOLLOWS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FOLLOWS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FOR integer;begin null; end;
/
insert into t2 values ('FOR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FOR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FORCE integer;begin null; end;
/
insert into t2 values ('FORCE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FORCE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FOREIGN integer;begin null; end;
/
insert into t2 values ('FOREIGN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FOREIGN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FORMAT integer;begin null; end;
/
insert into t2 values ('FORMAT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FORMAT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FOUND integer;begin null; end;
/
insert into t2 values ('FOUND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FOUND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FROM integer;begin null; end;
/
insert into t2 values ('FROM','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FROM'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FULL integer;begin null; end;
/
insert into t2 values ('FULL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FULL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FULLTEXT integer;begin null; end;
/
insert into t2 values ('FULLTEXT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FULLTEXT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FUNCTION integer;begin null; end;
/
insert into t2 values ('FUNCTION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FUNCTION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as GENERAL integer;begin null; end;
/
insert into t2 values ('GENERAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='GENERAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as GENERATED integer;begin null; end;
/
insert into t2 values ('GENERATED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='GENERATED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as GEOMETRY integer;begin null; end;
/
insert into t2 values ('GEOMETRY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='GEOMETRY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as GEOMETRYCOLLECTION integer;begin null; end;
/
insert into t2 values ('GEOMETRYCOLLECTION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='GEOMETRYCOLLECTION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as GET_FORMAT integer;begin null; end;
/
insert into t2 values ('GET_FORMAT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='GET_FORMAT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as GET integer;begin null; end;
/
insert into t2 values ('GET','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='GET'
/
commit
/
drop procedure f1
/ 
create procedure f1 as GLOBAL integer;begin null; end;
/
insert into t2 values ('GLOBAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='GLOBAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as GOTO integer;begin null; end;
/
insert into t2 values ('GOTO','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='GOTO'
/
commit
/
drop procedure f1
/ 
create procedure f1 as GRANT integer;begin null; end;
/
insert into t2 values ('GRANT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='GRANT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as GRANTS integer;begin null; end;
/
insert into t2 values ('GRANTS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='GRANTS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as GROUP integer;begin null; end;
/
insert into t2 values ('GROUP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='GROUP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as HANDLER integer;begin null; end;
/
insert into t2 values ('HANDLER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='HANDLER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as HARD integer;begin null; end;
/
insert into t2 values ('HARD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='HARD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as HASH integer;begin null; end;
/
insert into t2 values ('HASH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='HASH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as HAVING integer;begin null; end;
/
insert into t2 values ('HAVING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='HAVING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as HELP integer;begin null; end;
/
insert into t2 values ('HELP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='HELP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as HIGH_PRIORITY integer;begin null; end;
/
insert into t2 values ('HIGH_PRIORITY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='HIGH_PRIORITY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as HOST integer;begin null; end;
/
insert into t2 values ('HOST','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='HOST'
/
commit
/
drop procedure f1
/ 
create procedure f1 as HOSTS integer;begin null; end;
/
insert into t2 values ('HOSTS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='HOSTS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as HOUR integer;begin null; end;
/
insert into t2 values ('HOUR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='HOUR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as HOUR_MICROSECOND integer;begin null; end;
/
insert into t2 values ('HOUR_MICROSECOND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='HOUR_MICROSECOND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as HOUR_MINUTE integer;begin null; end;
/
insert into t2 values ('HOUR_MINUTE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='HOUR_MINUTE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as HOUR_SECOND integer;begin null; end;
/
insert into t2 values ('HOUR_SECOND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='HOUR_SECOND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ID integer;begin null; end;
/
insert into t2 values ('ID','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ID'
/
commit
/
drop procedure f1
/ 
create procedure f1 as IDENTIFIED integer;begin null; end;
/
insert into t2 values ('IDENTIFIED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='IDENTIFIED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as IF integer;begin null; end;
/
insert into t2 values ('IF','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='IF'
/
commit
/
drop procedure f1
/ 
create procedure f1 as IGNORE integer;begin null; end;
/
insert into t2 values ('IGNORE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='IGNORE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as IGNORE_DOMAIN_IDS integer;begin null; end;
/
insert into t2 values ('IGNORE_DOMAIN_IDS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='IGNORE_DOMAIN_IDS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as IGNORE_SERVER_IDS integer;begin null; end;
/
insert into t2 values ('IGNORE_SERVER_IDS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='IGNORE_SERVER_IDS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as IMMEDIATE integer;begin null; end;
/
insert into t2 values ('IMMEDIATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='IMMEDIATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as IMPORT integer;begin null; end;
/
insert into t2 values ('IMPORT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='IMPORT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as IN integer;begin null; end;
/
insert into t2 values ('IN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='IN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INDEX integer;begin null; end;
/
insert into t2 values ('INDEX','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INDEX'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INDEXES integer;begin null; end;
/
insert into t2 values ('INDEXES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INDEXES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INFILE integer;begin null; end;
/
insert into t2 values ('INFILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INFILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INITIAL_SIZE integer;begin null; end;
/
insert into t2 values ('INITIAL_SIZE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INITIAL_SIZE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INNER integer;begin null; end;
/
insert into t2 values ('INNER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INNER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INOUT integer;begin null; end;
/
insert into t2 values ('INOUT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INOUT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INSENSITIVE integer;begin null; end;
/
insert into t2 values ('INSENSITIVE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INSENSITIVE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INSERT integer;begin null; end;
/
insert into t2 values ('INSERT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INSERT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INSERT_METHOD integer;begin null; end;
/
insert into t2 values ('INSERT_METHOD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INSERT_METHOD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INSTALL integer;begin null; end;
/
insert into t2 values ('INSTALL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INSTALL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INT integer;begin null; end;
/
insert into t2 values ('INT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INT1 integer;begin null; end;
/
insert into t2 values ('INT1','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INT1'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INT2 integer;begin null; end;
/
insert into t2 values ('INT2','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INT2'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INT3 integer;begin null; end;
/
insert into t2 values ('INT3','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INT3'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INT4 integer;begin null; end;
/
insert into t2 values ('INT4','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INT4'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INT8 integer;begin null; end;
/
insert into t2 values ('INT8','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INT8'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INTEGER integer;begin null; end;
/
insert into t2 values ('INTEGER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INTEGER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INTERVAL integer;begin null; end;
/
insert into t2 values ('INTERVAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INTERVAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INTO integer;begin null; end;
/
insert into t2 values ('INTO','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INTO'
/
commit
/
drop procedure f1
/ 
create procedure f1 as IO integer;begin null; end;
/
insert into t2 values ('IO','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='IO'
/
commit
/
drop procedure f1
/ 
create procedure f1 as IO_THREAD integer;begin null; end;
/
insert into t2 values ('IO_THREAD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='IO_THREAD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as IPC integer;begin null; end;
/
insert into t2 values ('IPC','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='IPC'
/
commit
/
drop procedure f1
/ 
create procedure f1 as IS integer;begin null; end;
/
insert into t2 values ('IS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='IS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ISOLATION integer;begin null; end;
/
insert into t2 values ('ISOLATION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ISOLATION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ISOPEN integer;begin null; end;
/
insert into t2 values ('ISOPEN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ISOPEN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ISSUER integer;begin null; end;
/
insert into t2 values ('ISSUER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ISSUER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ITERATE integer;begin null; end;
/
insert into t2 values ('ITERATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ITERATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as INVOKER integer;begin null; end;
/
insert into t2 values ('INVOKER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='INVOKER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as JOIN integer;begin null; end;
/
insert into t2 values ('JOIN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='JOIN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as JSON integer;begin null; end;
/
insert into t2 values ('JSON','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='JSON'
/
commit
/
drop procedure f1
/ 
create procedure f1 as KEY integer;begin null; end;
/
insert into t2 values ('KEY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='KEY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as KEYS integer;begin null; end;
/
insert into t2 values ('KEYS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='KEYS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as KEY_BLOCK_SIZE integer;begin null; end;
/
insert into t2 values ('KEY_BLOCK_SIZE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='KEY_BLOCK_SIZE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as KILL integer;begin null; end;
/
insert into t2 values ('KILL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='KILL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LANGUAGE integer;begin null; end;
/
insert into t2 values ('LANGUAGE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LANGUAGE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LAST integer;begin null; end;
/
insert into t2 values ('LAST','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LAST'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LAST_VALUE integer;begin null; end;
/
insert into t2 values ('LAST_VALUE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LAST_VALUE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LEADING integer;begin null; end;
/
insert into t2 values ('LEADING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LEADING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LEAVE integer;begin null; end;
/
insert into t2 values ('LEAVE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LEAVE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LEAVES integer;begin null; end;
/
insert into t2 values ('LEAVES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LEAVES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LEFT integer;begin null; end;
/
insert into t2 values ('LEFT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LEFT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LESS integer;begin null; end;
/
insert into t2 values ('LESS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LESS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LEVEL integer;begin null; end;
/
insert into t2 values ('LEVEL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LEVEL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LIKE integer;begin null; end;
/
insert into t2 values ('LIKE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LIKE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LIMIT integer;begin null; end;
/
insert into t2 values ('LIMIT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LIMIT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LINEAR integer;begin null; end;
/
insert into t2 values ('LINEAR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LINEAR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LINES integer;begin null; end;
/
insert into t2 values ('LINES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LINES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LINESTRING integer;begin null; end;
/
insert into t2 values ('LINESTRING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LINESTRING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LIST integer;begin null; end;
/
insert into t2 values ('LIST','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LIST'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LOAD integer;begin null; end;
/
insert into t2 values ('LOAD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LOAD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LOCAL integer;begin null; end;
/
insert into t2 values ('LOCAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LOCAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LOCALTIME integer;begin null; end;
/
insert into t2 values ('LOCALTIME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LOCALTIME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LOCALTIMESTAMP integer;begin null; end;
/
insert into t2 values ('LOCALTIMESTAMP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LOCALTIMESTAMP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LOCK integer;begin null; end;
/
insert into t2 values ('LOCK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LOCK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LOCKS integer;begin null; end;
/
insert into t2 values ('LOCKS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LOCKS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LOGFILE integer;begin null; end;
/
insert into t2 values ('LOGFILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LOGFILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LOGS integer;begin null; end;
/
insert into t2 values ('LOGS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LOGS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LONG integer;begin null; end;
/
insert into t2 values ('LONG','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LONG'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LONGBLOB integer;begin null; end;
/
insert into t2 values ('LONGBLOB','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LONGBLOB'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LONGTEXT integer;begin null; end;
/
insert into t2 values ('LONGTEXT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LONGTEXT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LOOP integer;begin null; end;
/
insert into t2 values ('LOOP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LOOP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LOW_PRIORITY integer;begin null; end;
/
insert into t2 values ('LOW_PRIORITY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LOW_PRIORITY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER integer;begin null; end;
/
insert into t2 values ('MASTER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_CONNECT_RETRY integer;begin null; end;
/
insert into t2 values ('MASTER_CONNECT_RETRY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_CONNECT_RETRY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_DELAY integer;begin null; end;
/
insert into t2 values ('MASTER_DELAY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_DELAY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_GTID_POS integer;begin null; end;
/
insert into t2 values ('MASTER_GTID_POS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_GTID_POS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_HOST integer;begin null; end;
/
insert into t2 values ('MASTER_HOST','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_HOST'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_LOG_FILE integer;begin null; end;
/
insert into t2 values ('MASTER_LOG_FILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_LOG_FILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_LOG_POS integer;begin null; end;
/
insert into t2 values ('MASTER_LOG_POS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_LOG_POS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_PASSWORD integer;begin null; end;
/
insert into t2 values ('MASTER_PASSWORD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_PASSWORD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_PORT integer;begin null; end;
/
insert into t2 values ('MASTER_PORT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_PORT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_SERVER_ID integer;begin null; end;
/
insert into t2 values ('MASTER_SERVER_ID','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_SERVER_ID'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_SSL integer;begin null; end;
/
insert into t2 values ('MASTER_SSL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_SSL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_SSL_CA integer;begin null; end;
/
insert into t2 values ('MASTER_SSL_CA','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_SSL_CA'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_SSL_CAPATH integer;begin null; end;
/
insert into t2 values ('MASTER_SSL_CAPATH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_SSL_CAPATH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_SSL_CERT integer;begin null; end;
/
insert into t2 values ('MASTER_SSL_CERT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_SSL_CERT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_SSL_CIPHER integer;begin null; end;
/
insert into t2 values ('MASTER_SSL_CIPHER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_SSL_CIPHER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_SSL_CRL integer;begin null; end;
/
insert into t2 values ('MASTER_SSL_CRL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_SSL_CRL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_SSL_CRLPATH integer;begin null; end;
/
insert into t2 values ('MASTER_SSL_CRLPATH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_SSL_CRLPATH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_SSL_KEY integer;begin null; end;
/
insert into t2 values ('MASTER_SSL_KEY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_SSL_KEY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_SSL_VERIFY_SERVER_CERT integer;begin null; end;
/
insert into t2 values ('MASTER_SSL_VERIFY_SERVER_CERT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_SSL_VERIFY_SERVER_CERT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_USER integer;begin null; end;
/
insert into t2 values ('MASTER_USER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_USER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_USE_GTID integer;begin null; end;
/
insert into t2 values ('MASTER_USE_GTID','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_USE_GTID'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MASTER_HEARTBEAT_PERIOD integer;begin null; end;
/
insert into t2 values ('MASTER_HEARTBEAT_PERIOD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MASTER_HEARTBEAT_PERIOD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MATCH integer;begin null; end;
/
insert into t2 values ('MATCH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MATCH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MAX_CONNECTIONS_PER_HOUR integer;begin null; end;
/
insert into t2 values ('MAX_CONNECTIONS_PER_HOUR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MAX_CONNECTIONS_PER_HOUR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MAX_QUERIES_PER_HOUR integer;begin null; end;
/
insert into t2 values ('MAX_QUERIES_PER_HOUR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MAX_QUERIES_PER_HOUR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MAX_ROWS integer;begin null; end;
/
insert into t2 values ('MAX_ROWS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MAX_ROWS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MAX_SIZE integer;begin null; end;
/
insert into t2 values ('MAX_SIZE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MAX_SIZE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MAX_STATEMENT_TIME integer;begin null; end;
/
insert into t2 values ('MAX_STATEMENT_TIME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MAX_STATEMENT_TIME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MAX_UPDATES_PER_HOUR integer;begin null; end;
/
insert into t2 values ('MAX_UPDATES_PER_HOUR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MAX_UPDATES_PER_HOUR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MAX_USER_CONNECTIONS integer;begin null; end;
/
insert into t2 values ('MAX_USER_CONNECTIONS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MAX_USER_CONNECTIONS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MAXVALUE integer;begin null; end;
/
insert into t2 values ('MAXVALUE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MAXVALUE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MEDIUM integer;begin null; end;
/
insert into t2 values ('MEDIUM','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MEDIUM'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MEDIUMBLOB integer;begin null; end;
/
insert into t2 values ('MEDIUMBLOB','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MEDIUMBLOB'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MEDIUMINT integer;begin null; end;
/
insert into t2 values ('MEDIUMINT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MEDIUMINT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MEDIUMTEXT integer;begin null; end;
/
insert into t2 values ('MEDIUMTEXT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MEDIUMTEXT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MEMORY integer;begin null; end;
/
insert into t2 values ('MEMORY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MEMORY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MERGE integer;begin null; end;
/
insert into t2 values ('MERGE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MERGE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MESSAGE_TEXT integer;begin null; end;
/
insert into t2 values ('MESSAGE_TEXT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MESSAGE_TEXT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MICROSECOND integer;begin null; end;
/
insert into t2 values ('MICROSECOND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MICROSECOND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MIDDLEINT integer;begin null; end;
/
insert into t2 values ('MIDDLEINT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MIDDLEINT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MIGRATE integer;begin null; end;
/
insert into t2 values ('MIGRATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MIGRATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MINUTE integer;begin null; end;
/
insert into t2 values ('MINUTE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MINUTE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MINUTE_MICROSECOND integer;begin null; end;
/
insert into t2 values ('MINUTE_MICROSECOND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MINUTE_MICROSECOND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MINUTE_SECOND integer;begin null; end;
/
insert into t2 values ('MINUTE_SECOND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MINUTE_SECOND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MIN_ROWS integer;begin null; end;
/
insert into t2 values ('MIN_ROWS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MIN_ROWS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MOD integer;begin null; end;
/
insert into t2 values ('MOD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MOD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MODE integer;begin null; end;
/
insert into t2 values ('MODE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MODE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MODIFIES integer;begin null; end;
/
insert into t2 values ('MODIFIES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MODIFIES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MODIFY integer;begin null; end;
/
insert into t2 values ('MODIFY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MODIFY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MONTH integer;begin null; end;
/
insert into t2 values ('MONTH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MONTH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MULTILINESTRING integer;begin null; end;
/
insert into t2 values ('MULTILINESTRING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MULTILINESTRING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MULTIPOINT integer;begin null; end;
/
insert into t2 values ('MULTIPOINT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MULTIPOINT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MULTIPOLYGON integer;begin null; end;
/
insert into t2 values ('MULTIPOLYGON','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MULTIPOLYGON'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MUTEX integer;begin null; end;
/
insert into t2 values ('MUTEX','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MUTEX'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MYSQL integer;begin null; end;
/
insert into t2 values ('MYSQL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MYSQL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MYSQL_ERRNO integer;begin null; end;
/
insert into t2 values ('MYSQL_ERRNO','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MYSQL_ERRNO'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NAME integer;begin null; end;
/
insert into t2 values ('NAME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NAME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NAMES integer;begin null; end;
/
insert into t2 values ('NAMES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NAMES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NATIONAL integer;begin null; end;
/
insert into t2 values ('NATIONAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NATIONAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NATURAL integer;begin null; end;
/
insert into t2 values ('NATURAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NATURAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NCHAR integer;begin null; end;
/
insert into t2 values ('NCHAR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NCHAR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NEW integer;begin null; end;
/
insert into t2 values ('NEW','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NEW'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NEXT integer;begin null; end;
/
insert into t2 values ('NEXT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NEXT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NO integer;begin null; end;
/
insert into t2 values ('NO','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NO'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NO_WAIT integer;begin null; end;
/
insert into t2 values ('NO_WAIT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NO_WAIT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NODEGROUP integer;begin null; end;
/
insert into t2 values ('NODEGROUP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NODEGROUP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NONE integer;begin null; end;
/
insert into t2 values ('NONE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NONE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NOT integer;begin null; end;
/
insert into t2 values ('NOT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NOT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NOTFOUND integer;begin null; end;
/
insert into t2 values ('NOTFOUND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NOTFOUND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NO_WRITE_TO_BINLOG integer;begin null; end;
/
insert into t2 values ('NO_WRITE_TO_BINLOG','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NO_WRITE_TO_BINLOG'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NULL integer;begin null; end;
/
insert into t2 values ('NULL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NULL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NUMBER integer;begin null; end;
/
insert into t2 values ('NUMBER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NUMBER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NUMERIC integer;begin null; end;
/
insert into t2 values ('NUMERIC','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NUMERIC'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NVARCHAR integer;begin null; end;
/
insert into t2 values ('NVARCHAR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NVARCHAR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OFFSET integer;begin null; end;
/
insert into t2 values ('OFFSET','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OFFSET'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OLD_PASSWORD integer;begin null; end;
/
insert into t2 values ('OLD_PASSWORD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OLD_PASSWORD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ON integer;begin null; end;
/
insert into t2 values ('ON','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ON'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ONE integer;begin null; end;
/
insert into t2 values ('ONE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ONE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ONLINE integer;begin null; end;
/
insert into t2 values ('ONLINE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ONLINE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ONLY integer;begin null; end;
/
insert into t2 values ('ONLY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ONLY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OPEN integer;begin null; end;
/
insert into t2 values ('OPEN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OPEN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OPTIMIZE integer;begin null; end;
/
insert into t2 values ('OPTIMIZE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OPTIMIZE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OPTIONS integer;begin null; end;
/
insert into t2 values ('OPTIONS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OPTIONS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OPTION integer;begin null; end;
/
insert into t2 values ('OPTION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OPTION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OPTIONALLY integer;begin null; end;
/
insert into t2 values ('OPTIONALLY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OPTIONALLY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OR integer;begin null; end;
/
insert into t2 values ('OR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ORDER integer;begin null; end;
/
insert into t2 values ('ORDER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ORDER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OTHERS integer;begin null; end;
/
insert into t2 values ('OTHERS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OTHERS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OUT integer;begin null; end;
/
insert into t2 values ('OUT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OUT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OUTER integer;begin null; end;
/
insert into t2 values ('OUTER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OUTER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OUTFILE integer;begin null; end;
/
insert into t2 values ('OUTFILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OUTFILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OVER integer;begin null; end;
/
insert into t2 values ('OVER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OVER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as OWNER integer;begin null; end;
/
insert into t2 values ('OWNER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='OWNER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PACKAGE integer;begin null; end;
/
insert into t2 values ('PACKAGE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PACKAGE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PACK_KEYS integer;begin null; end;
/
insert into t2 values ('PACK_KEYS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PACK_KEYS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PAGE integer;begin null; end;
/
insert into t2 values ('PAGE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PAGE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PAGE_CHECKSUM integer;begin null; end;
/
insert into t2 values ('PAGE_CHECKSUM','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PAGE_CHECKSUM'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PARSER integer;begin null; end;
/
insert into t2 values ('PARSER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PARSER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PARSE_VCOL_EXPR integer;begin null; end;
/
insert into t2 values ('PARSE_VCOL_EXPR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PARSE_VCOL_EXPR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PARTIAL integer;begin null; end;
/
insert into t2 values ('PARTIAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PARTIAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PARTITION integer;begin null; end;
/
insert into t2 values ('PARTITION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PARTITION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PARTITIONING integer;begin null; end;
/
insert into t2 values ('PARTITIONING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PARTITIONING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PARTITIONS integer;begin null; end;
/
insert into t2 values ('PARTITIONS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PARTITIONS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PASSWORD integer;begin null; end;
/
insert into t2 values ('PASSWORD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PASSWORD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PERSISTENT integer;begin null; end;
/
insert into t2 values ('PERSISTENT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PERSISTENT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PHASE integer;begin null; end;
/
insert into t2 values ('PHASE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PHASE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PLUGIN integer;begin null; end;
/
insert into t2 values ('PLUGIN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PLUGIN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PLUGINS integer;begin null; end;
/
insert into t2 values ('PLUGINS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PLUGINS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as POINT integer;begin null; end;
/
insert into t2 values ('POINT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='POINT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as POLYGON integer;begin null; end;
/
insert into t2 values ('POLYGON','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='POLYGON'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PORT integer;begin null; end;
/
insert into t2 values ('PORT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PORT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PRECEDES integer;begin null; end;
/
insert into t2 values ('PRECEDES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PRECEDES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PRECEDING integer;begin null; end;
/
insert into t2 values ('PRECEDING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PRECEDING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PRECISION integer;begin null; end;
/
insert into t2 values ('PRECISION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PRECISION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PREPARE integer;begin null; end;
/
insert into t2 values ('PREPARE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PREPARE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PRESERVE integer;begin null; end;
/
insert into t2 values ('PRESERVE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PRESERVE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PREV integer;begin null; end;
/
insert into t2 values ('PREV','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PREV'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PRIMARY integer;begin null; end;
/
insert into t2 values ('PRIMARY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PRIMARY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PRIVILEGES integer;begin null; end;
/
insert into t2 values ('PRIVILEGES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PRIVILEGES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PROCEDURE integer;begin null; end;
/
insert into t2 values ('PROCEDURE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PROCEDURE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PROCESS integer;begin null; end;
/
insert into t2 values ('PROCESS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PROCESS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PROCESSLIST integer;begin null; end;
/
insert into t2 values ('PROCESSLIST','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PROCESSLIST'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PROFILE integer;begin null; end;
/
insert into t2 values ('PROFILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PROFILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PROFILES integer;begin null; end;
/
insert into t2 values ('PROFILES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PROFILES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PROXY integer;begin null; end;
/
insert into t2 values ('PROXY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PROXY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PURGE integer;begin null; end;
/
insert into t2 values ('PURGE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PURGE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as QUARTER integer;begin null; end;
/
insert into t2 values ('QUARTER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='QUARTER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as QUERY integer;begin null; end;
/
insert into t2 values ('QUERY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='QUERY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as QUICK integer;begin null; end;
/
insert into t2 values ('QUICK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='QUICK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RAISE integer;begin null; end;
/
insert into t2 values ('RAISE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RAISE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RANGE integer;begin null; end;
/
insert into t2 values ('RANGE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RANGE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RAW integer;begin null; end;
/
insert into t2 values ('RAW','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RAW'
/
commit
/
drop procedure f1
/ 
create procedure f1 as READ integer;begin null; end;
/
insert into t2 values ('READ','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='READ'
/
commit
/
drop procedure f1
/ 
create procedure f1 as READ_ONLY integer;begin null; end;
/
insert into t2 values ('READ_ONLY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='READ_ONLY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as READ_WRITE integer;begin null; end;
/
insert into t2 values ('READ_WRITE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='READ_WRITE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as READS integer;begin null; end;
/
insert into t2 values ('READS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='READS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REAL integer;begin null; end;
/
insert into t2 values ('REAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REBUILD integer;begin null; end;
/
insert into t2 values ('REBUILD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REBUILD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RECOVER integer;begin null; end;
/
insert into t2 values ('RECOVER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RECOVER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RECURSIVE integer;begin null; end;
/
insert into t2 values ('RECURSIVE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RECURSIVE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REDO_BUFFER_SIZE integer;begin null; end;
/
insert into t2 values ('REDO_BUFFER_SIZE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REDO_BUFFER_SIZE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REDOFILE integer;begin null; end;
/
insert into t2 values ('REDOFILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REDOFILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REDUNDANT integer;begin null; end;
/
insert into t2 values ('REDUNDANT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REDUNDANT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REFERENCES integer;begin null; end;
/
insert into t2 values ('REFERENCES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REFERENCES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REGEXP integer;begin null; end;
/
insert into t2 values ('REGEXP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REGEXP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RELAY integer;begin null; end;
/
insert into t2 values ('RELAY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RELAY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RELAYLOG integer;begin null; end;
/
insert into t2 values ('RELAYLOG','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RELAYLOG'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RELAY_LOG_FILE integer;begin null; end;
/
insert into t2 values ('RELAY_LOG_FILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RELAY_LOG_FILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RELAY_LOG_POS integer;begin null; end;
/
insert into t2 values ('RELAY_LOG_POS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RELAY_LOG_POS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RELAY_THREAD integer;begin null; end;
/
insert into t2 values ('RELAY_THREAD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RELAY_THREAD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RELEASE integer;begin null; end;
/
insert into t2 values ('RELEASE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RELEASE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RELOAD integer;begin null; end;
/
insert into t2 values ('RELOAD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RELOAD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REMOVE integer;begin null; end;
/
insert into t2 values ('REMOVE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REMOVE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RENAME integer;begin null; end;
/
insert into t2 values ('RENAME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RENAME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REORGANIZE integer;begin null; end;
/
insert into t2 values ('REORGANIZE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REORGANIZE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REPAIR integer;begin null; end;
/
insert into t2 values ('REPAIR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REPAIR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REPEATABLE integer;begin null; end;
/
insert into t2 values ('REPEATABLE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REPEATABLE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REPLACE integer;begin null; end;
/
insert into t2 values ('REPLACE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REPLACE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REPLICATION integer;begin null; end;
/
insert into t2 values ('REPLICATION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REPLICATION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REPEAT integer;begin null; end;
/
insert into t2 values ('REPEAT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REPEAT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REQUIRE integer;begin null; end;
/
insert into t2 values ('REQUIRE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REQUIRE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RESET integer;begin null; end;
/
insert into t2 values ('RESET','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RESET'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RESIGNAL integer;begin null; end;
/
insert into t2 values ('RESIGNAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RESIGNAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RESTORE integer;begin null; end;
/
insert into t2 values ('RESTORE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RESTORE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RESTRICT integer;begin null; end;
/
insert into t2 values ('RESTRICT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RESTRICT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RESUME integer;begin null; end;
/
insert into t2 values ('RESUME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RESUME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RETURNED_SQLSTATE integer;begin null; end;
/
insert into t2 values ('RETURNED_SQLSTATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RETURNED_SQLSTATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RETURN integer;begin null; end;
/
insert into t2 values ('RETURN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RETURN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RETURNING integer;begin null; end;
/
insert into t2 values ('RETURNING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RETURNING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RETURNS integer;begin null; end;
/
insert into t2 values ('RETURNS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RETURNS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REUSE integer;begin null; end;
/
insert into t2 values ('REUSE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REUSE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REVERSE integer;begin null; end;
/
insert into t2 values ('REVERSE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REVERSE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REVOKE integer;begin null; end;
/
insert into t2 values ('REVOKE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REVOKE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RIGHT integer;begin null; end;
/
insert into t2 values ('RIGHT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RIGHT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RLIKE integer;begin null; end;
/
insert into t2 values ('RLIKE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RLIKE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ROLE integer;begin null; end;
/
insert into t2 values ('ROLE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ROLE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ROLLBACK integer;begin null; end;
/
insert into t2 values ('ROLLBACK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ROLLBACK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ROLLUP integer;begin null; end;
/
insert into t2 values ('ROLLUP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ROLLUP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ROUTINE integer;begin null; end;
/
insert into t2 values ('ROUTINE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ROUTINE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ROW integer;begin null; end;
/
insert into t2 values ('ROW','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ROW'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ROWCOUNT integer;begin null; end;
/
insert into t2 values ('ROWCOUNT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ROWCOUNT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ROWS integer;begin null; end;
/
insert into t2 values ('ROWS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ROWS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ROW_COUNT integer;begin null; end;
/
insert into t2 values ('ROW_COUNT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ROW_COUNT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ROW_FORMAT integer;begin null; end;
/
insert into t2 values ('ROW_FORMAT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ROW_FORMAT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RTREE integer;begin null; end;
/
insert into t2 values ('RTREE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RTREE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SAVEPOINT integer;begin null; end;
/
insert into t2 values ('SAVEPOINT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SAVEPOINT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SCHEDULE integer;begin null; end;
/
insert into t2 values ('SCHEDULE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SCHEDULE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SCHEMA integer;begin null; end;
/
insert into t2 values ('SCHEMA','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SCHEMA'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SCHEMA_NAME integer;begin null; end;
/
insert into t2 values ('SCHEMA_NAME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SCHEMA_NAME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SCHEMAS integer;begin null; end;
/
insert into t2 values ('SCHEMAS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SCHEMAS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SECOND integer;begin null; end;
/
insert into t2 values ('SECOND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SECOND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SECOND_MICROSECOND integer;begin null; end;
/
insert into t2 values ('SECOND_MICROSECOND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SECOND_MICROSECOND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SECURITY integer;begin null; end;
/
insert into t2 values ('SECURITY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SECURITY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SELECT integer;begin null; end;
/
insert into t2 values ('SELECT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SELECT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SENSITIVE integer;begin null; end;
/
insert into t2 values ('SENSITIVE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SENSITIVE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SEPARATOR integer;begin null; end;
/
insert into t2 values ('SEPARATOR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SEPARATOR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SERIAL integer;begin null; end;
/
insert into t2 values ('SERIAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SERIAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SERIALIZABLE integer;begin null; end;
/
insert into t2 values ('SERIALIZABLE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SERIALIZABLE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SESSION integer;begin null; end;
/
insert into t2 values ('SESSION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SESSION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SERVER integer;begin null; end;
/
insert into t2 values ('SERVER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SERVER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SET integer;begin null; end;
/
insert into t2 values ('SET','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SET'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SHARE integer;begin null; end;
/
insert into t2 values ('SHARE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SHARE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SHOW integer;begin null; end;
/
insert into t2 values ('SHOW','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SHOW'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SHUTDOWN integer;begin null; end;
/
insert into t2 values ('SHUTDOWN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SHUTDOWN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SIGNAL integer;begin null; end;
/
insert into t2 values ('SIGNAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SIGNAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SIGNED integer;begin null; end;
/
insert into t2 values ('SIGNED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SIGNED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SIMPLE integer;begin null; end;
/
insert into t2 values ('SIMPLE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SIMPLE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SLAVE integer;begin null; end;
/
insert into t2 values ('SLAVE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SLAVE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SLAVES integer;begin null; end;
/
insert into t2 values ('SLAVES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SLAVES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SLAVE_POS integer;begin null; end;
/
insert into t2 values ('SLAVE_POS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SLAVE_POS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SLOW integer;begin null; end;
/
insert into t2 values ('SLOW','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SLOW'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SNAPSHOT integer;begin null; end;
/
insert into t2 values ('SNAPSHOT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SNAPSHOT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SMALLINT integer;begin null; end;
/
insert into t2 values ('SMALLINT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SMALLINT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SOCKET integer;begin null; end;
/
insert into t2 values ('SOCKET','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SOCKET'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SOFT integer;begin null; end;
/
insert into t2 values ('SOFT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SOFT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SOME integer;begin null; end;
/
insert into t2 values ('SOME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SOME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SONAME integer;begin null; end;
/
insert into t2 values ('SONAME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SONAME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SOUNDS integer;begin null; end;
/
insert into t2 values ('SOUNDS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SOUNDS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SOURCE integer;begin null; end;
/
insert into t2 values ('SOURCE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SOURCE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STORED integer;begin null; end;
/
insert into t2 values ('STORED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STORED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SPATIAL integer;begin null; end;
/
insert into t2 values ('SPATIAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SPATIAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SPECIFIC integer;begin null; end;
/
insert into t2 values ('SPECIFIC','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SPECIFIC'
/
commit
/
drop procedure f1
/ 
create procedure f1 as REF_SYSTEM_ID integer;begin null; end;
/
insert into t2 values ('REF_SYSTEM_ID','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='REF_SYSTEM_ID'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL integer;begin null; end;
/
insert into t2 values ('SQL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQLEXCEPTION integer;begin null; end;
/
insert into t2 values ('SQLEXCEPTION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQLEXCEPTION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQLSTATE integer;begin null; end;
/
insert into t2 values ('SQLSTATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQLSTATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQLWARNING integer;begin null; end;
/
insert into t2 values ('SQLWARNING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQLWARNING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_BIG_RESULT integer;begin null; end;
/
insert into t2 values ('SQL_BIG_RESULT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_BIG_RESULT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_BUFFER_RESULT integer;begin null; end;
/
insert into t2 values ('SQL_BUFFER_RESULT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_BUFFER_RESULT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_CACHE integer;begin null; end;
/
insert into t2 values ('SQL_CACHE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_CACHE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_CALC_FOUND_ROWS integer;begin null; end;
/
insert into t2 values ('SQL_CALC_FOUND_ROWS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_CALC_FOUND_ROWS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_NO_CACHE integer;begin null; end;
/
insert into t2 values ('SQL_NO_CACHE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_NO_CACHE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_SMALL_RESULT integer;begin null; end;
/
insert into t2 values ('SQL_SMALL_RESULT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_SMALL_RESULT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_THREAD integer;begin null; end;
/
insert into t2 values ('SQL_THREAD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_THREAD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_TSI_SECOND integer;begin null; end;
/
insert into t2 values ('SQL_TSI_SECOND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_TSI_SECOND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_TSI_MINUTE integer;begin null; end;
/
insert into t2 values ('SQL_TSI_MINUTE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_TSI_MINUTE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_TSI_HOUR integer;begin null; end;
/
insert into t2 values ('SQL_TSI_HOUR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_TSI_HOUR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_TSI_DAY integer;begin null; end;
/
insert into t2 values ('SQL_TSI_DAY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_TSI_DAY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_TSI_WEEK integer;begin null; end;
/
insert into t2 values ('SQL_TSI_WEEK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_TSI_WEEK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_TSI_MONTH integer;begin null; end;
/
insert into t2 values ('SQL_TSI_MONTH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_TSI_MONTH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_TSI_QUARTER integer;begin null; end;
/
insert into t2 values ('SQL_TSI_QUARTER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_TSI_QUARTER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SQL_TSI_YEAR integer;begin null; end;
/
insert into t2 values ('SQL_TSI_YEAR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SQL_TSI_YEAR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SSL integer;begin null; end;
/
insert into t2 values ('SSL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SSL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as START integer;begin null; end;
/
insert into t2 values ('START','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='START'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STARTING integer;begin null; end;
/
insert into t2 values ('STARTING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STARTING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STARTS integer;begin null; end;
/
insert into t2 values ('STARTS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STARTS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STATEMENT integer;begin null; end;
/
insert into t2 values ('STATEMENT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STATEMENT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STATS_AUTO_RECALC integer;begin null; end;
/
insert into t2 values ('STATS_AUTO_RECALC','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STATS_AUTO_RECALC'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STATS_PERSISTENT integer;begin null; end;
/
insert into t2 values ('STATS_PERSISTENT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STATS_PERSISTENT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STATS_SAMPLE_PAGES integer;begin null; end;
/
insert into t2 values ('STATS_SAMPLE_PAGES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STATS_SAMPLE_PAGES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STATUS integer;begin null; end;
/
insert into t2 values ('STATUS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STATUS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STOP integer;begin null; end;
/
insert into t2 values ('STOP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STOP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STORAGE integer;begin null; end;
/
insert into t2 values ('STORAGE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STORAGE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STRAIGHT_JOIN integer;begin null; end;
/
insert into t2 values ('STRAIGHT_JOIN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STRAIGHT_JOIN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STRING integer;begin null; end;
/
insert into t2 values ('STRING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STRING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SUBCLASS_ORIGIN integer;begin null; end;
/
insert into t2 values ('SUBCLASS_ORIGIN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SUBCLASS_ORIGIN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SUBJECT integer;begin null; end;
/
insert into t2 values ('SUBJECT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SUBJECT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SUBPARTITION integer;begin null; end;
/
insert into t2 values ('SUBPARTITION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SUBPARTITION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SUBPARTITIONS integer;begin null; end;
/
insert into t2 values ('SUBPARTITIONS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SUBPARTITIONS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SUPER integer;begin null; end;
/
insert into t2 values ('SUPER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SUPER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SUSPEND integer;begin null; end;
/
insert into t2 values ('SUSPEND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SUSPEND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SWAPS integer;begin null; end;
/
insert into t2 values ('SWAPS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SWAPS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SWITCHES integer;begin null; end;
/
insert into t2 values ('SWITCHES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SWITCHES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TABLE integer;begin null; end;
/
insert into t2 values ('TABLE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TABLE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TABLE_NAME integer;begin null; end;
/
insert into t2 values ('TABLE_NAME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TABLE_NAME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TABLES integer;begin null; end;
/
insert into t2 values ('TABLES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TABLES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TABLESPACE integer;begin null; end;
/
insert into t2 values ('TABLESPACE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TABLESPACE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TABLE_CHECKSUM integer;begin null; end;
/
insert into t2 values ('TABLE_CHECKSUM','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TABLE_CHECKSUM'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TEMPORARY integer;begin null; end;
/
insert into t2 values ('TEMPORARY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TEMPORARY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TEMPTABLE integer;begin null; end;
/
insert into t2 values ('TEMPTABLE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TEMPTABLE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TERMINATED integer;begin null; end;
/
insert into t2 values ('TERMINATED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TERMINATED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TEXT integer;begin null; end;
/
insert into t2 values ('TEXT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TEXT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as THAN integer;begin null; end;
/
insert into t2 values ('THAN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='THAN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as THEN integer;begin null; end;
/
insert into t2 values ('THEN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='THEN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TIES integer;begin null; end;
/
insert into t2 values ('TIES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TIES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TIME integer;begin null; end;
/
insert into t2 values ('TIME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TIME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TIMESTAMP integer;begin null; end;
/
insert into t2 values ('TIMESTAMP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TIMESTAMP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TIMESTAMPADD integer;begin null; end;
/
insert into t2 values ('TIMESTAMPADD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TIMESTAMPADD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TIMESTAMPDIFF integer;begin null; end;
/
insert into t2 values ('TIMESTAMPDIFF','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TIMESTAMPDIFF'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TINYBLOB integer;begin null; end;
/
insert into t2 values ('TINYBLOB','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TINYBLOB'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TINYINT integer;begin null; end;
/
insert into t2 values ('TINYINT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TINYINT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TINYTEXT integer;begin null; end;
/
insert into t2 values ('TINYTEXT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TINYTEXT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TO integer;begin null; end;
/
insert into t2 values ('TO','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TO'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TRAILING integer;begin null; end;
/
insert into t2 values ('TRAILING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TRAILING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TRANSACTION integer;begin null; end;
/
insert into t2 values ('TRANSACTION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TRANSACTION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TRANSACTIONAL integer;begin null; end;
/
insert into t2 values ('TRANSACTIONAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TRANSACTIONAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TRIGGER integer;begin null; end;
/
insert into t2 values ('TRIGGER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TRIGGER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TRIGGERS integer;begin null; end;
/
insert into t2 values ('TRIGGERS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TRIGGERS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TRUE integer;begin null; end;
/
insert into t2 values ('TRUE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TRUE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TRUNCATE integer;begin null; end;
/
insert into t2 values ('TRUNCATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TRUNCATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TYPE integer;begin null; end;
/
insert into t2 values ('TYPE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TYPE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TYPES integer;begin null; end;
/
insert into t2 values ('TYPES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TYPES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNBOUNDED integer;begin null; end;
/
insert into t2 values ('UNBOUNDED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNBOUNDED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNCOMMITTED integer;begin null; end;
/
insert into t2 values ('UNCOMMITTED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNCOMMITTED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNDEFINED integer;begin null; end;
/
insert into t2 values ('UNDEFINED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNDEFINED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNDO_BUFFER_SIZE integer;begin null; end;
/
insert into t2 values ('UNDO_BUFFER_SIZE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNDO_BUFFER_SIZE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNDOFILE integer;begin null; end;
/
insert into t2 values ('UNDOFILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNDOFILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNDO integer;begin null; end;
/
insert into t2 values ('UNDO','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNDO'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNICODE integer;begin null; end;
/
insert into t2 values ('UNICODE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNICODE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNION integer;begin null; end;
/
insert into t2 values ('UNION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNIQUE integer;begin null; end;
/
insert into t2 values ('UNIQUE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNIQUE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNKNOWN integer;begin null; end;
/
insert into t2 values ('UNKNOWN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNKNOWN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNLOCK integer;begin null; end;
/
insert into t2 values ('UNLOCK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNLOCK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNINSTALL integer;begin null; end;
/
insert into t2 values ('UNINSTALL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNINSTALL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNSIGNED integer;begin null; end;
/
insert into t2 values ('UNSIGNED','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNSIGNED'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UNTIL integer;begin null; end;
/
insert into t2 values ('UNTIL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UNTIL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UPDATE integer;begin null; end;
/
insert into t2 values ('UPDATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UPDATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UPGRADE integer;begin null; end;
/
insert into t2 values ('UPGRADE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UPGRADE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as USAGE integer;begin null; end;
/
insert into t2 values ('USAGE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='USAGE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as USE integer;begin null; end;
/
insert into t2 values ('USE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='USE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as USER integer;begin null; end;
/
insert into t2 values ('USER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='USER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as USER_RESOURCES integer;begin null; end;
/
insert into t2 values ('USER_RESOURCES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='USER_RESOURCES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as USE_FRM integer;begin null; end;
/
insert into t2 values ('USE_FRM','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='USE_FRM'
/
commit
/
drop procedure f1
/ 
create procedure f1 as USING integer;begin null; end;
/
insert into t2 values ('USING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='USING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UTC_DATE integer;begin null; end;
/
insert into t2 values ('UTC_DATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UTC_DATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UTC_TIME integer;begin null; end;
/
insert into t2 values ('UTC_TIME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UTC_TIME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as UTC_TIMESTAMP integer;begin null; end;
/
insert into t2 values ('UTC_TIMESTAMP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='UTC_TIMESTAMP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VALUE integer;begin null; end;
/
insert into t2 values ('VALUE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VALUE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VALUES integer;begin null; end;
/
insert into t2 values ('VALUES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VALUES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VARBINARY integer;begin null; end;
/
insert into t2 values ('VARBINARY','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VARBINARY'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VARCHAR integer;begin null; end;
/
insert into t2 values ('VARCHAR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VARCHAR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VARCHARACTER integer;begin null; end;
/
insert into t2 values ('VARCHARACTER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VARCHARACTER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VARCHAR2 integer;begin null; end;
/
insert into t2 values ('VARCHAR2','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VARCHAR2'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VARIABLES integer;begin null; end;
/
insert into t2 values ('VARIABLES','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VARIABLES'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VARYING integer;begin null; end;
/
insert into t2 values ('VARYING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VARYING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VIA integer;begin null; end;
/
insert into t2 values ('VIA','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VIA'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VIEW integer;begin null; end;
/
insert into t2 values ('VIEW','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VIEW'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VIRTUAL integer;begin null; end;
/
insert into t2 values ('VIRTUAL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VIRTUAL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as WAIT integer;begin null; end;
/
insert into t2 values ('WAIT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='WAIT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as WARNINGS integer;begin null; end;
/
insert into t2 values ('WARNINGS','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='WARNINGS'
/
commit
/
drop procedure f1
/ 
create procedure f1 as WEEK integer;begin null; end;
/
insert into t2 values ('WEEK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='WEEK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as WEIGHT_STRING integer;begin null; end;
/
insert into t2 values ('WEIGHT_STRING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='WEIGHT_STRING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as WHEN integer;begin null; end;
/
insert into t2 values ('WHEN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='WHEN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as WHERE integer;begin null; end;
/
insert into t2 values ('WHERE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='WHERE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as WHILE integer;begin null; end;
/
insert into t2 values ('WHILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='WHILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as WINDOW integer;begin null; end;
/
insert into t2 values ('WINDOW','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='WINDOW'
/
commit
/
drop procedure f1
/ 
create procedure f1 as WITH integer;begin null; end;
/
insert into t2 values ('WITH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='WITH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as WORK integer;begin null; end;
/
insert into t2 values ('WORK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='WORK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as WRAPPER integer;begin null; end;
/
insert into t2 values ('WRAPPER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='WRAPPER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as WRITE integer;begin null; end;
/
insert into t2 values ('WRITE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='WRITE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as X509 integer;begin null; end;
/
insert into t2 values ('X509','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='X509'
/
commit
/
drop procedure f1
/ 
create procedure f1 as XOR integer;begin null; end;
/
insert into t2 values ('XOR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='XOR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as XA integer;begin null; end;
/
insert into t2 values ('XA','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='XA'
/
commit
/
drop procedure f1
/ 
create procedure f1 as XML integer;begin null; end;
/
insert into t2 values ('XML','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='XML'
/
commit
/
drop procedure f1
/ 
create procedure f1 as YEAR integer;begin null; end;
/
insert into t2 values ('YEAR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='YEAR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as YEAR_MONTH integer;begin null; end;
/
insert into t2 values ('YEAR_MONTH','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='YEAR_MONTH'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ZEROFILL integer;begin null; end;
/
insert into t2 values ('ZEROFILL','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ZEROFILL'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ADDDATE integer;begin null; end;
/
insert into t2 values ('ADDDATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ADDDATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BIT_AND integer;begin null; end;
/
insert into t2 values ('BIT_AND','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BIT_AND'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BIT_OR integer;begin null; end;
/
insert into t2 values ('BIT_OR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BIT_OR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as BIT_XOR integer;begin null; end;
/
insert into t2 values ('BIT_XOR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='BIT_XOR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CAST integer;begin null; end;
/
insert into t2 values ('CAST','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CAST'
/
commit
/
drop procedure f1
/ 
create procedure f1 as COUNT integer;begin null; end;
/
insert into t2 values ('COUNT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='COUNT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CUME_DIST integer;begin null; end;
/
insert into t2 values ('CUME_DIST','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CUME_DIST'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CURDATE integer;begin null; end;
/
insert into t2 values ('CURDATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CURDATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as CURTIME integer;begin null; end;
/
insert into t2 values ('CURTIME','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='CURTIME'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DATE_ADD integer;begin null; end;
/
insert into t2 values ('DATE_ADD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DATE_ADD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DATE_SUB integer;begin null; end;
/
insert into t2 values ('DATE_SUB','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DATE_SUB'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DECODE integer;begin null; end;
/
insert into t2 values ('DECODE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DECODE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as DENSE_RANK integer;begin null; end;
/
insert into t2 values ('DENSE_RANK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='DENSE_RANK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as EXTRACT integer;begin null; end;
/
insert into t2 values ('EXTRACT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='EXTRACT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as FIRST_VALUE integer;begin null; end;
/
insert into t2 values ('FIRST_VALUE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='FIRST_VALUE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as GROUP_CONCAT integer;begin null; end;
/
insert into t2 values ('GROUP_CONCAT','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='GROUP_CONCAT'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LAG integer;begin null; end;
/
insert into t2 values ('LAG','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LAG'
/
commit
/
drop procedure f1
/ 
create procedure f1 as LEAD integer;begin null; end;
/
insert into t2 values ('LEAD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='LEAD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MAX integer;begin null; end;
/
insert into t2 values ('MAX','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MAX'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MID integer;begin null; end;
/
insert into t2 values ('MID','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MID'
/
commit
/
drop procedure f1
/ 
create procedure f1 as MIN integer;begin null; end;
/
insert into t2 values ('MIN','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='MIN'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NOW integer;begin null; end;
/
insert into t2 values ('NOW','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NOW'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NTH_VALUE integer;begin null; end;
/
insert into t2 values ('NTH_VALUE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NTH_VALUE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as NTILE integer;begin null; end;
/
insert into t2 values ('NTILE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='NTILE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as POSITION integer;begin null; end;
/
insert into t2 values ('POSITION','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='POSITION'
/
commit
/
drop procedure f1
/ 
create procedure f1 as PERCENT_RANK integer;begin null; end;
/
insert into t2 values ('PERCENT_RANK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='PERCENT_RANK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as RANK integer;begin null; end;
/
insert into t2 values ('RANK','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='RANK'
/
commit
/
drop procedure f1
/ 
create procedure f1 as ROW_NUMBER integer;begin null; end;
/
insert into t2 values ('ROW_NUMBER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='ROW_NUMBER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SESSION_USER integer;begin null; end;
/
insert into t2 values ('SESSION_USER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SESSION_USER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STD integer;begin null; end;
/
insert into t2 values ('STD','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STD'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STDDEV integer;begin null; end;
/
insert into t2 values ('STDDEV','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STDDEV'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STDDEV_POP integer;begin null; end;
/
insert into t2 values ('STDDEV_POP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STDDEV_POP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as STDDEV_SAMP integer;begin null; end;
/
insert into t2 values ('STDDEV_SAMP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='STDDEV_SAMP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SUBDATE integer;begin null; end;
/
insert into t2 values ('SUBDATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SUBDATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SUBSTR integer;begin null; end;
/
insert into t2 values ('SUBSTR','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SUBSTR'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SUBSTRING integer;begin null; end;
/
insert into t2 values ('SUBSTRING','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SUBSTRING'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SUM integer;begin null; end;
/
insert into t2 values ('SUM','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SUM'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SYSDATE integer;begin null; end;
/
insert into t2 values ('SYSDATE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SYSDATE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as SYSTEM_USER integer;begin null; end;
/
insert into t2 values ('SYSTEM_USER','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='SYSTEM_USER'
/
commit
/
drop procedure f1
/ 
create procedure f1 as TRIM integer;begin null; end;
/
insert into t2 values ('TRIM','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='TRIM'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VARIANCE integer;begin null; end;
/
insert into t2 values ('VARIANCE','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VARIANCE'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VAR_POP integer;begin null; end;
/
insert into t2 values ('VAR_POP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VAR_POP'
/
commit
/
drop procedure f1
/ 
create procedure f1 as VAR_SAMP integer;begin null; end;
/
insert into t2 values ('VAR_SAMP','??')
/
commit
/
update t2 set result=decode((select count(*)
                               from information_schema.routines
                              where routine_name='F1'),0,'KO','OK')
 where name='VAR_SAMP'
/
commit
/
drop procedure f1
/ 
select result,name from t2 order by name asc 
/


