输入两个参数: select gametime1 as gametime, username1 as username from dual就出错 ORA-00600: 内部错误代码,参数: [15212], [1], [], [], [], [], [], []
create or replace procedure p_single_test(sid in char,gametime in char,gametype in char) as begin MERGE INTO single_test B USING (select gametime from dual) E ON (b.game_time=gametime) WHEN MATCHED THEN update set game_type=gametype WHEN NOT MATCHED THEN INSERT (b.id,b.game_time) VALUES (sid,gametime); end;
on (b.game_time=gametime) 不要用E.gametime
szsmall(麒麟) : 如果select gametime from dual,是一个参数没问题 如果是多个参数select gametime,username....,就会出现我说得到问题
select gametime1 as gametime, username1 as username from dual就出错
ORA-00600: 内部错误代码,参数: [15212], [1], [], [], [], [], [], []
begin
MERGE INTO single_test B
USING (select gametime from dual) E
ON (b.game_time=gametime)
WHEN MATCHED THEN
update set game_type=gametype
WHEN NOT MATCHED THEN
INSERT (b.id,b.game_time)
VALUES (sid,gametime);
end;
如果select gametime from dual,是一个参数没问题
如果是多个参数select gametime,username....,就会出现我说得到问题