Oracle ORA-00600：内部错误代码,参数：[qctcte1],[0],[],[],[],[],[],[]

创建储存过程的时候出错：

create or replace procedure p_showChart(myOrgId in number)
as
begin
select m.organize_id,m.parent_id,m.name_en,m.org_flag,s.sur_name||' '||s.first_name headName,org.name,t6.num from mng_organize m right join (
select t5.sid,sum(t5.num) num from
(
select connect_by_root t4.organize_id as sid,t4.num from
(
select t3.organize_id,t3.parent_id,count(t3.staff_id) as num from
(
select t1.organize_id,t1.parent_id,t2.staff_id from
(select t.* from mng_organize t start with t.organize_id=myOrgId connect by prior t.organize_id=t.parent_id
)t1 left join (select * from hr_staff h where h.delete_flag='N' and h.enabled_flag='Y' and h.status_id not in(500583,500584) ) t2 on t1.organize_id = t2.dept_id
)t3 group by t3.organize_id,t3.parent_id
)t4 connect by prior t4.organize_id=t4.parent_id
)t5 group by t5.sid
)t6 on m.organize_id=t6.sid
left join hr_staff s on m.staff_id=s.staff_id
left join org_duties_type org on s.position_id = org.duties_type_id
order by m.parent_id asc;
end;


里面的代码直接运行 没有问题

这个存储过程就是一关连查询，没有into子句，
也没有具体的可执行操作。
建议你去看下存储过程的基本语法……

+1

参数里加一个 out 参数
例如 create or replace procedure p_showChart(myOrgId in number, ocursor out sys_refcursor)
使用 open ocursor for
  select ....