在Oracle 11g2 XE中编译PLSQL函数有时会导致ORA-00600：内部错误

概述我有一个PL / SQL函数,我正在使用它有时编译好,但有时给我这个错误. ORA-00600: internal error code, arguments: [17285], [0x318FDE2C], [1], [0x273F1C60], [], [], [], [], [], [], [], []00600. 00000 - "internal error code, argument 我有一个PL / sql函数,我正在使用它有时编译好,但有时给我这个错误.

ORA-00600: internal error code,arguments: [17285],[0x318FDE2C],[1],[0x273F1C60],[],[]00600. 00000 -  "internal error code,arguments: [%s],[%s],[%s]"*Cause:    This is the generic internal error number for Oracle program       exceptions.  This indicates that a process has encountered an       exceptional condition.*Action:   Report as a BUG - the first argument is the internal error number

断开连接并重新连接到Oracle和函数编译确定感到疯狂……

谷歌搜索错误代码和参数给了我这个

ERROR:ORA-600 [17285] [a] [b] [c]VERSIONS:versions 7.0 to 10.1DESCRIPTION:Oracle is in the process of deleting an instantiation object when itdiscovers that the object is currently on the call stack.This should not occur and so ORA-600 [17285] is reported.ARGUMENTS:Arg [a] Instantiation objectArg [b] Call stack nesting levelArg [c] library Cache Object HandleFUNCTIONAliTY:Kernel Generic Instantiation managerIMPACT:PROCESS FAILURENON CORRUPTIVE - no corruption to underlying data.SUGGESTIONS:This error is usually accompanIEd by another error. Please check for this.

我的函数返回一个自定义的表格类型.大多数功能代码遗漏了……

CREATE TYPE t_solexp_row AS OBJECT (obj         VARCHAR(30),dt          DATE,param       VARCHAR(30),param_ID    NUMBER,val         NUMBER,change_time TIMESTAMP);/CREATE TYPE t_solexp_tab IS table OF t_solexp_row;/CREATE OR REPLACE FUNCTION get_solexp_tab(p_start_date IN DATE,p_end_date IN DATE) RETURN t_solexp_tab PIPEliNED ASBEGIN    ...    LOOP        PIPE ROW(t_solexp_row(...,...,...);    END LOOP;    ...    RETURN;END;/

任何可能导致这种行为的想法？

这不是一个自我回答的问题,但我写了一个想法,谢谢Stackoverflow！ 总结

以上是内存溢出为你收集整理的在Oracle 11g2 XE中编译PL / SQL函数有时会导致ORA-00600：内部错误全部内容，希望文章能够帮你解决在Oracle 11g2 XE中编译PL / SQL函数有时会导致ORA-00600：内部错误所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。