Oracle数据库中常见报错问题
1、工资单发放----新建工资单模板时显示系统异常无法进行下一步

      解决方法：在数据库中执行以下语句,第一句执行成功后再执行第二句，如果第一句执行失败请勿执行下面的！！！！！！

	-- 创建临时表HRSA_SALARY_TEMPLAT_TEMPT 结构与数据和HRSA_SALARY_TEMPLATE一样
	create table HRSA_SALARY_TEMPLAT_TEMPT as select * from HRSA_SALARY_TEMPLATE;

	-- 删除原表HRSA_SALARY_TEMPLATE数据
	delete from HRSA_SALARY_TEMPLATE;

    alter TABLE HRSA_SALARY_TEMPLATE MODIFY SALARY_ITEM_SETTING NULL;
	alter table HRSA_SALARY_TEMPLATE modify salary_item_setting long;
	alter table HRSA_SALARY_TEMPLATE modify salary_item_setting CLOB;
	insert into HRSA_SALARY_TEMPLATE  select * from HRSA_SALARY_TEMPLAT_TEMPT ;
	alter TABLE HRSA_SALARY_TEMPLATE MODIFY SALARY_ITEM_SETTING NOT NULL;
	drop table  HRSA_SALARY_TEMPLAT_TEMPT;











2、工资单发放----发放工资单时显示系统异常无法进行下一步
    
      解决方法：在数据库中执行以下语句,第一句执行成功后再执行第二句，如果第一句执行失败请勿执行下面的！！！！！！


	-- 创建临时表HRSA_SALARY_SEND_INFO_TEMPI结构与数据和HRSA_SALARY_SEND_INFO一样
	create table HRSA_SALARY_SEND_INFO_TEMPI as select * from HRSA_SALARY_SEND_INFO;
	
	-- 删除原表HRSA_SALARY_SEND_INFO数据
	delete from HRSA_SALARY_SEND_INFO;

	alter table HRSA_SALARY_SEND_INFO modify SALARY_TEMPLATE long;
	alter table HRSA_SALARY_SEND_INFO modify SALARY_TEMPLATE CLOB;
	insert into HRSA_SALARY_SEND_INFO select * from HRSA_SALARY_SEND_INFO_TEMPI;
	drop table  HRSA_SALARY_SEND_INFO_TEMPI;






