SELECT A.dm
FROM (select *
from dom
connect by stats = prior stats_m
start with num = 44030000000000000016) A
WHERE A.dm IN ('03', '05', '06')
AND bz = 'Y'
ORDER BY A.dm
这是我用的SQL语句,把这条语句放在ORACLE 10G中报出:
"保存信息失败:数据检索失败:java.sql.SQLException: ORA-00600: 内部错误代码, 参数: [qkacon:FJswrwo], [3], [], [], [], [], [], []"
错误.
请哪为大哥能告诉我这条语句该怎么改....
小弟在线急等.............
FROM (select *
from dom
connect by stats = prior stats_m
start with num = 44030000000000000016) A
WHERE A.dm IN ('03', '05', '06')
AND bz = 'Y'
ORDER BY A.dm
这是我用的SQL语句,把这条语句放在ORACLE 10G中报出:
"保存信息失败:数据检索失败:java.sql.SQLException: ORA-00600: 内部错误代码, 参数: [qkacon:FJswrwo], [3], [], [], [], [], [], []"
错误.
请哪为大哥能告诉我这条语句该怎么改....
小弟在线急等.............
一步步分析
SELECT
*
FROM dom
connect by stats = prior
stats_m start with num = 44030000000000000016
SELECT
*
FROM dom
connect by stats = prior
stats_m start with num = 44030000000000000016
就报
"保存信息失败:数据检索失败:java.sql.SQLException: ORA-00600: 内部错误代码, 参数: [qkacon:FJswrwo], [3], [], [], [], [], [], []"
这个错误,原因就是这个语句...
但是我在测试机用的挺好的,换了个数据库就不行了..
都是ORACLE10G...
现在用的ORACLE 的版本是:10.2.0.3.0
我看下..
哈哈
用:select * from dom where num = 44030000000000000016 就能查询
试试
SELECT *
FROM dom
stats_m start with num = 44030000000000000016
connect by stats = prior
升级oracle的补丁