在Oracle 11g2 XE中编译PL / SQL函数偶然会导致ORA-00600:内部
发布时间:2021-05-20 21:58:41 所属栏目:站长百科 来源:网络整理
导读:我有一个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
我有一个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.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; / 任何也许导致这种举动的设法? 这不是一个自我答复的题目,但我写了一个设法,感谢Stackoverflow!(编辑:湖南网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |