是你这个语句引发了ORA-00600错误SELECT COUNT(*) INTO B
FROM DUAL
WHERE (:NEW.ZWID,:NEW.SPID) NOT IN (SELECT A.ZWID,A.SPID
FROM YWXSMX A
GROUP BY A.ZWID,A.SPID
HAVING SUM(A.XSSL)>0 OR SUM(A.ZSSL)>0);在ORACLE 9.0.1.1.1中存在一些BUGS,其中有一个BUG就是不能将变量和“IN”同时用在SQL语句中。
建议楼主进行PATCH。
FROM DUAL
WHERE (:NEW.ZWID,:NEW.SPID) NOT IN (SELECT A.ZWID,A.SPID
FROM YWXSMX A
GROUP BY A.ZWID,A.SPID
HAVING SUM(A.XSSL)>0 OR SUM(A.ZSSL)>0);在ORACLE 9.0.1.1.1中存在一些BUGS,其中有一个BUG就是不能将变量和“IN”同时用在SQL语句中。
建议楼主进行PATCH。
file corruption
failed data checks in memory
hardware, memory, or I/O errors
incorrectly restored files The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of the Oracle Server. Action: Report this error to customer support after gathering the following information: events that led up to the error
the operations that were attempted that led to the error
the conditions of the operating system and database at the time ofthe error
any unusual circumstances that occurred before receiving theORA-00600 message
contents of any trace files generated by the error
the relevant portions of the Alert fileNote: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.