WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool SYS_SESSION_S.log


prompt
prompt Creating sequence SYS_SESSION_S
prompt ============================
prompt
whenever sqlerror continue
drop sequence SYS_SESSION_S;
whenever sqlerror exit failure rollback

create sequence SYS_SESSION_S
minvalue 100000
maxvalue 999999999999999999999999999
start with 100000
increment by 1
cache 20;

  
spool off
 
exit
