ORA-01722: 无效数字



select o from Scenic o where o.nameCn like'%崂山风景名胜区%' and o.auditState=4 order by o.recDegree desc
[dtss] 2013-06-05 10:32:16,882 ERROR [http-8080-1] org.hibernate.util.JDBCExceptionReporter.logExceptions-78 | ORA-01722: 无效数字
select * from user
where
INSTR( (select '芦祥,' || field || ','历链 from table_a where id = 1), ','肢哗孙 || TRIM(TO_CHAR(user_id )) || ',' ) > 0