大佬教程收集整理的这篇文章主要介绍了在Oracle 11g2 XE中编译PL / SQL函数有时会导致ORA-00600:内部错误,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
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.1 DESCRIPTION: Oracle is in the process of deleting an instantiation object when it discovers that the object is currently on the call stack. This should not occur and so ORA-600 [17285] is reported. ARGUMENTS: Arg [a] Instantiation object Arg [b] Call stack nesTing level Arg [c] library Cache Object Handle FUNCTIONAliTY: Kernel Generic Instantiation manager IMPACT: PROCESS FAILURE NON 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 AS BEGIN ... LOOP PIPE ROW(t_solexp_row(...,...,...); END LOOP; ... RETURN; END; /
任何可能导致这种行为的想法?
以上是大佬教程为你收集整理的在Oracle 11g2 XE中编译PL / SQL函数有时会导致ORA-00600:内部错误全部内容,希望文章能够帮你解决在Oracle 11g2 XE中编译PL / SQL函数有时会导致ORA-00600:内部错误所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。