i have problem :error information:ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "OBLICORE.TARGET", line 8
ORA-04088: error during execution of trigger 'OBLICORE.TARGET
how to resolve this problem?my trigger:CREATE OR REPLACE TRIGGER target AFTER INSERT on ZwischenFOR EACH ROWDECLARE
keyname varchar2(50) :='';
information varchar2(50) := :new.Info;BEGIN
select distinct Keyword
into keyname
from Hilfe;
IF instr(information, keyname) >0 THENINSERT INTO Ziel VALUES ( keyname , :new.Info);
END IF;
END target;
ORA-06512: at "OBLICORE.TARGET", line 8
ORA-04088: error during execution of trigger 'OBLICORE.TARGET
how to resolve this problem?my trigger:CREATE OR REPLACE TRIGGER target AFTER INSERT on ZwischenFOR EACH ROWDECLARE
keyname varchar2(50) :='';
information varchar2(50) := :new.Info;BEGIN
select distinct Keyword
into keyname
from Hilfe;
IF instr(information, keyname) >0 THENINSERT INTO Ziel VALUES ( keyname , :new.Info);
END IF;
END target;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货