TOAD数据库回档出现警告：准备启用约束条件。。。成功终止导入，但出现警告。有个应用出现问题，INSERT不能正确执行，没反应了。
11.jpg (168.65 KB, 下载次数: 66)
下载附件
2016-4-15 16:56 上传
33.png (69.6 KB, 下载次数: 65)
下载附件
2016-4-15 16:58 上传
22.jpg (70.71 KB, 下载次数: 67)
下载附件
2016-4-15 16:58 上传
程序包PROJECT:PROCEDURE PROJECTLIST_INS
(
name_in IN MGCODER.PROJECTLIST.name%TYPE,
shortname_in IN MGCODER.PROJECTLIST.shortname%TYPE,
code_in IN MGCODER.PROJECTLIST.code%TYPE,
remark_in IN MGCODER.PROJECTLIST.remark%TYPE,
projectstate_in IN MGCODER.PROJECTLIST.projectstate%TYPE,
operatorid_in IN MGCODER.PROJECTLIST.operatorid%TYPE,
Belongto_in in MGCODER.PROJECTLIST.belongto%type,
PlanDate_in in MGCODER.PROJECTLIST.PLANBEGINDATE%type,
FactBeginDate_in in MGCODER.PROJECTLIST.FACTBEGINDATE%type,
FactFinishDate_in in MGCODER.PROJECTLIST.FACTFINISHDATE%type,
IMPORTANTFLAG_in in MGCODER.projectlist.IMPORTANTFLAG%type
);
程序包体：
PROCEDURE PROJECTLIST_INS
(
name_in IN MGCODER.PROJECTLIST.name%TYPE,
shortname_in IN MGCODER.PROJECTLIST.shortname%TYPE,
code_in IN MGCODER.PROJECTLIST.code%TYPE,
remark_in IN MGCODER.PROJECTLIST.remark%TYPE,
projectstate_in IN MGCODER.PROJECTLIST.projectstate%TYPE,
operatorid_in IN MGCODER.PROJECTLIST.operatorid%TYPE,
Belongto_in in MGCODER.PROJECTLIST.belongto%type,
PlanDate_in in MGCODER.PROJECTLIST.PLANBEGINDATE%type,
FactBeginDate_in in MGCODER.PROJECTLIST.FACTBEGINDATE%type,
FactFinishDate_in in MGCODER.PROJECTLIST.FACTFINISHDATE%type,
IMPORTANTFLAG_in in MGCODER.projectlist.IMPORTANTFLAG%type
)
IS
BEGIN
INSERT INTO MGCODER.PROJECTLIST
(
PROJECTID,
NAME,
SHORTNAME,
CODE,
REMARK,
PROJECTSTATE,
OPERATORID,
BELONGTO, PLANBEGINDATE,
FACTBEGINDATE, FACTFINISHDATE,IMPORTANTFLAG
)
VALUES
(
To_char(PBILKey.nextVal),
NAME_in,
SHORTNAME_in,
CODE_in,
REMARK_in,
PROJECTSTATE_in,
OPERATORID_in,
Belongto_in,
PlanDate_in,
FactBeginDate_in,
FactFinishDate_in,
IMPORTANTFLAG_in
);
commit;
ProjectManage.InsertPrecomputeProject(name_in,shortname_in,code_in,remark_in,projectstate_in,operatorid_in);
END; /* PROJECTLIST_INS */
应用程序没有问题，回档后只有这个表不能插入数据，求大侠高手赐教，急。
|
