WHENEVER SQLERROR EXIT FAILURE ROLLBACK; 
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;
spool SYS_ROLE.sql.log 
set feedback off
set define off 

Insert into SYS_ROLE (ROLE_ID,ROLE_CODE,ROLE_NAME_ID,DESCRIPTION_ID,START_DATE,END_DATE,SERVICE_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY) values (41,'TEST',1005,1006,to_date('2012-06-20 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,null,to_date('2012-06-20 14:47:11','YYYY-MM-DD HH24:MI:SS'),21,to_date('2012-06-20 14:47:11','YYYY-MM-DD HH24:MI:SS'),21);
Insert into SYS_ROLE (ROLE_ID,ROLE_CODE,ROLE_NAME_ID,DESCRIPTION_ID,START_DATE,END_DATE,SERVICE_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY) values (21,'ADMIN',61,62,to_date('2012-06-12 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,null,to_date('2012-07-02 14:33:46','YYYY-MM-DD HH24:MI:SS'),21,to_date('2012-06-12 15:14:33','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_ROLE (ROLE_ID,ROLE_CODE,ROLE_NAME_ID,DESCRIPTION_ID,START_DATE,END_DATE,SERVICE_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY) values (81,'MANAGER',1263,1264,to_date('2012-07-20 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,null,to_date('2012-07-03 14:45:58','YYYY-MM-DD HH24:MI:SS'),21,to_date('2012-07-03 14:45:58','YYYY-MM-DD HH24:MI:SS'),21);

commit; 
set feedback on  
set define on 
spool off 
exit 
 