oracle stored procedure 실행시 에러가 아닌 이상한 무한 루프가 돕니다.
안녕하세요.
애니프레임을 이용해서 스토어드프로시져를 실행하고 있습니다.
토드에서나 sqlplus에서 돌리면 에러가 발생하지 않습니다.
그런데 웹서비스를 이용해서 돌리면 에러가 아닌 무한루프가 돕니다.
아래와 같은 메세지가 계속 나오는데 무엇때문이 알 수 가 없네요.
뭐가 문젠가요? 실행하는 소스는...
Impl에서는 String str = this.useMgrDao.use("F",useHistVo, wsResponseUseMgrBody);
dao에서는 Map results = queryService.execute("callUseProcedure", inVal);
queryservice에는
{ call SP_USE_CCASH(?,?,?,?,?,?,?,?,?,?,?, ?,?,?, ?,?)}
이런식으로 되어 있습니다.
너무 답답해 죽겠네요.
2010-02-17 17:22:55,264 INFO [anyframe.core.query.impl.jdbc.PagingJdbcTemplate] Added default SqlReturnUpdateCount parameter named #update-count-11073
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getMoreResults() returned false
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getUpdateCount() returned 1
2010-02-17 17:22:55,264 INFO [anyframe.core.query.impl.jdbc.PagingJdbcTemplate] Added default SqlReturnUpdateCount parameter named #update-count-11074
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getMoreResults() returned false
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getUpdateCount() returned 1
2010-02-17 17:22:55,264 INFO [anyframe.core.query.impl.jdbc.PagingJdbcTemplate] Added default SqlReturnUpdateCount parameter named #update-count-11075
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getMoreResults() returned false
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getUpdateCount() returned 1
2010-02-17 17:22:55,264 INFO [anyframe.core.query.impl.jdbc.PagingJdbcTemplate] Added default SqlReturnUpdateCount parameter named #update-count-11076
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getMoreResults() returned false
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getUpdateCount() returned 1
2010-02-17 17:22:55,264 INFO [anyframe.core.query.impl.jdbc.PagingJdbcTemplate] Added default SqlReturnUpdateCount parameter named #update-count-11077
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getMoreResults() returned false
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getUpdateCount() returned 1
2010-02-17 17:22:55,264 INFO [anyframe.core.query.impl.jdbc.PagingJdbcTemplate] Added default SqlReturnUpdateCount parameter named #update-count-11078
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getMoreResults() returned false
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getUpdateCount() returned 1
2010-02-17 17:22:55,264 INFO [anyframe.core.query.impl.jdbc.PagingJdbcTemplate] Added default SqlReturnUpdateCount parameter named #update-count-11079
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getMoreResults() returned false
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getUpdateCount() returned 1
2010-02-17 17:22:55,264 INFO [anyframe.core.query.impl.jdbc.PagingJdbcTemplate] Added default SqlReturnUpdateCount parameter named #update-count-11080
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getMoreResults() returned false
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getUpdateCount() returned 1
2010-02-17 17:22:55,264 INFO [anyframe.core.query.impl.jdbc.PagingJdbcTemplate] Added default SqlReturnUpdateCount parameter named #update-count-11081
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getMoreResults() returned false
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getUpdateCount() returned 1
2010-02-17 17:22:55,264 INFO [anyframe.core.query.impl.jdbc.PagingJdbcTemplate] Added default SqlReturnUpdateCount parameter named #update-count-11082
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getMoreResults() returned false
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getUpdateCount() returned 1
2010-02-17 17:22:55,264 INFO [anyframe.core.query.impl.jdbc.PagingJdbcTemplate] Added default SqlReturnUpdateCount parameter named #update-count-11083
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getMoreResults() returned false
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getUpdateCount() returned 1
2010-02-17 17:22:55,264 INFO [anyframe.core.query.impl.jdbc.PagingJdbcTemplate] Added default SqlReturnUpdateCount parameter named #update-count-11084
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getMoreResults() returned false
2010-02-17 17:22:55,264 INFO [jdbc.audit] 5. CallableStatement.getUpdateCount() returned 1


자문자답
ojdbc-14.jar를 최신버전으로 하니까 문제가 해결됩니다.