Spool Script_Di_Prova.log

prompt "Questo è uno script di prova"

prompt "Alter table MYTABLE..."
Alter Table MYTABLE Add MYCOLUMN Char(2);

prompt "Compila Oggetti Invalidi..."
Execute CompilaInvalidi; 

prompt "Compila package PK_MYPACKAGE"
@PK_MYPACKAGE.pks
@PK_MYPACKAGE.pkb

prompt "Compila Oggetti Invalidi..."
Execute CompilaInvalidi; 

prompt "Aggiorna MYTABLE"
Update MYTABLE
   Set MYCOLUMN = '**';

COMMIT;

prompt "Fine Script"

Spool off;