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                                                                 >
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [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                                                                 ]; nested exception is java.sql.SQLException: ORA-00904: "PKG_SEARCH_TOOL"."QUERYUSERADDGOLD": 标识符无效Caused by: java.sql.SQLException: ORA-00904: "PKG_SEARCH_TOOL"."QUERYUSERADDGOLD": 标识符无效 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1264)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:390)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:343)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:405)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:413)
at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:444)
at com.chinaunicomchuangfu.dao.impl.InterFaceQueryDAO.userLoginDAO(InterFaceQueryDAO.java:220)
at com.chinaunicomchuangfu.service.impl.InterfaceServiceImpl.LoginServer(InterfaceServiceImpl.java:194)
at com.chinaunicomchuangfu.action.LoginAction.handleRequest(LoginAction.java:72)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:858)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:792)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.chinaunicomchuangfu.filter.RequestFilter.doFilterInternal(RequestFilter.java:75)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
大家帮我看看啊

解决方案 »

  1.   

    根据经验，猜测你的数据库有一个帐号 是pkg_search_tool，这个账号下有一个函数queryUserAddgold。 如果我的猜测是对的话，报错原因就是：你当前帐号没有执行这个函数的权限， 你需要给当前帐号赋予执行这个函数的权限。
      

  2.   

    queryUserAddgold 是什么？ pkg_search_tool 又是什么？
      

  3.   

    其实我也不知道 这都是什么这个sql是别人 写的
      

  4.   


    额，其实我也不知道， 这个是别人写的一条sql语句，用于查询登陆的吧
      

  5.   


    额，其实我也不知道， 这个是别人写的一条sql语句，用于查询登陆的吧
    就想 1# 说的，你先检查一下能不能访问到pkg_search_tool .queryUserAddgold 吧