ORA-03113 通信通道的文件结束!求助!

发布网友 发布时间：2022-05-03 05:49

我来回答

共6个回答

热心网友 时间：2022-05-05 17:49

str_content varchar2(200);
count0 number(10);
count1 number(10);
BEGIN
str_content:=substr(CONTENT,1,1);
if str_content = 'B' or str_content = 'b' then
count0:=0;
count1:=0;

这个好像是中毒了吧！！

热心网友 时间：2022-05-05 19:07

CREATE OR REPLACE PROCEDURE VOTECOUNT(
CONTENT IN VARCHAR2,
TEL IN VARCHAR2
)
IS
str_content varchar2(200);
count0 number(10);
count1 number(10);
BEGIN
str_content:=substr(CONTENT,1,1);
if str_content = 'B' or str_content = 'b' then
count0:=0;
count1:=0;
select count(*) into count0 from "MMS"."MMS_votecountt" where MMS_VOTETEL=TEL and to_char(MMS_DATE,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD');
if count0<=0 then
insert into "MMS"."MMS_votecountt"(MMS_VOTETEL) values(TEL);
else
select MMS_COUNT into count1 from "MMS"."MMS_votecountt" where MMS_VOTETEL=TEL and to_char(MMS_DATE,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD');
count1:=count1+1;
UPDATE "MMS"."MMS_votecountt" set MMS_COUNT=count1 where MMS_VOTETEL=TEL and to_char(MMS_DATE,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD');
end if;
else
count0:=0;
count1:=0;
select count(*) into count0 from "MMS"."MMS_votecount" where MMS_VOTETEL=TEL and to_char(MMS_DATE,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD');
if count0<=0 then
insert into "MMS"."MMS_votecount"(MMS_VOTETEL) values(TEL);
else
select MMS_COUNT into count1 from "MMS"."MMS_votecount" where MMS_VOTETEL=TEL and to_char(MMS_DATE,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD');
count1:=count1+1;
UPDATE "MMS"."MMS_votecount" set MMS_COUNT=count1 where MMS_VOTETEL=TEL and to_char(MMS_DATE,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD');
end if;
end if;
END;
/

触发器

create or replace trigger MMS_VOTECOUNTTWO
before insert on "MMS"."MMS_voteone" for each row
begin
VOTECOUNT(:new.MMS_CONTENT,:new.MMS_USERTEL);
end;
/

commit;

热心网友 时间：2022-05-05 20:41

CREATE OR REPLACE PROCEDURE VOTECOUNT
CONTENT IN VARCHAR2,
TEL IN VARCHAR2
IS
str_content varchar2(200);
count0 number(10);
count1 number(10);
BEGIN
str_content:=substr(CONTENT,1,1);
if str_content = 'B' or str_content = 'b' then
count0:=0;
count1:=0;
select count(*) into count0 from "MMS"."MMS_votecountt" where MMS_VOTETEL=TEL and to_char(MMS_DATE,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD');
if count0<=0 then
insert into "MMS"."MMS_votecountt"(MMS_VOTETEL) values(TEL);
else
select MMS_COUNT into count1 from "MMS"."MMS_votecountt" where MMS_VOTETEL=TEL and to_char(MMS_DATE,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD');
count1:=count1+1;
UPDATE "MMS"."MMS_votecountt" set MMS_COUNT=count1 where MMS_VOTETEL=TEL and to_char(MMS_DATE,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD');
end if;
else
count0:=0;
count1:=0;
select count(*) into count0 from "MMS"."MMS_votecount" where MMS_VOTETEL=TEL and to_char(MMS_DATE,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD');
if count0<=0 then
insert into "MMS"."MMS_votecount"(MMS_VOTETEL) values(TEL);
else
select MMS_COUNT into count1 from "MMS"."MMS_votecount" where MMS_VOTETEL=TEL and to_char(MMS_DATE,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD');
count1:=count1+1;
UPDATE "MMS"."MMS_votecount" set MMS_COUNT=count1 where MMS_VOTETEL=TEL and to_char(MMS_DATE,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD');
end if;
end if;
END;
/
create or replace trigger MMS_VOTECOUNTTWO
before insert on "MMS"."MMS_voteone" for each row
begin
VOTECOUNT(:new.MMS_CONTENT,:new.MMS_USERTEL);
end;
/
commit;

热心网友 时间：2022-05-05 22:33

可能是你电脑程序出了问题，或者中了一些专门破坏系统的病毒，建议您重装系统或者找专业人员查看查看,或者开机时按F8，进入Windows配置，选择最后一次配置，就可以恢复了。如果以上方法不行，加Q22166520（解除电脑疑难的Q群），那里有很多专业人员！！

热心网友 时间：2022-05-06 00:41

你是干什么的，好像是和我一个专业的

热心网友 时间：2022-05-06 03:05

我都想学
你可以教我吗