50 lines
1.7 KiB
Plaintext
50 lines
1.7 KiB
Plaintext
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;
|
|
|
|
|
|
|
|
|
|
|
|
|