阅读背景:

oracle在查询一条sql时,报 ORA-00904: "PKG_SEARCH_TOOL"."QUERYUSERADDGOLD": 标识符无效 这个错

来源:互联网 
2016-09-01 10:21:57,813 INFO [com.chinaunicomchuangfu.dao.impl.InterFaceQueryDAO] - <Method:userLoginDAO.sql=select xa.channelTypeID channelTypeID,                                                                        xa.successs successs,                                                                                  xa.channelTypeName channelTypeName,                                                                    xa.channelID channelID,                                                                                xa.channelName channelName,                                                                            xa.departmentID departmentID,                                                                          xa.userName userName,                                                                                  case when  xa.coinsCount is null or  xa.coinsCount<=0  then 0 else xa.coinsCount end coinsCount,       case when  xa.coinsCount is null or  xa.coinsCount<=0  then '0' else '1' end isAddCoins           from (select '1' successs,                                                                                          f_cha_typ_id channelTypeID,                                                                            f_cha_typ_name channelTypeName,                                                                        f_channel_id channelID,                                                                                f_channel_name channelName,                                                                            f_dep_id departmentID,                                                                                 f_dep_name departmentName,                                                                             x.f_user_name userName,                                                                                pkg_search_tool.queryUserAddgold('13066666666') coinsCount                                        from tm_user_info x                                                                                   where f_user_id = '13066666666'           and f_user_pwd = '1c0f70cb097bd6ed821419a3a2b29da0'           and f_user_status = '1') xa                                                                 > 2016-09-01 10:21:57,813 INFO [com.chinaunicomch



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: