????Oracle????????ORA-01403
????ORA-06512: ?? "MALL.PUB_YANG_LOGON_ORGAN"?? line 88
????ORA-06512: ?? line 1
????at com.yangcq.flow.processflow.ProcessflowFunction.execute(ProcessflowFunction.java:102)
????at com.opensymphony.workflow.AbstractWorkflow.executeFunction(AbstractWorkflow.java:869)
????at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(AbstractWorkflow.java:1042)
????at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.java:567)
????at com.yangcq.flow.processflow.BaseProcessflow.executeProcessflow(BaseProcessflow.java:65)
????at com.yangcq.flow.processflow.BaseProcessflow.executeProcessflow(BaseProcessflow.java:39)
????at com.yangcq.web.spring.DefaultFlowExecuteHandler.executeProcessflow(DefaultFlowExecuteHandler.java:58)
????at com.yangcq.service.ProcessflowExecuteService.execute(ProcessflowExecuteService.java:164)
????at com.yangcq.flow.processflow.function.ProcessflowExecFunction.exec(ProcessflowExecFunction.java:33)
????... 48 more
????Caused by: com.yangcq.Exception: root cause: SqlMapClient operation; SQL [];
????--- The error occurred in config/sqlmap/public.xml.
????--- The error occurred while applying a parameter map.
????--- Check the public.pwdErrorOperate.
????--- Check the statement (update procedure failed).
????--- Cause: java.sql.SQLException: ORA-01403: δ????κ?????
????88?е?SQL??????????????????????????д?????????????????????????
????SELECT
????LCL_LASTFAIL??LCL_FAILTODAY INTO V_LASTDATE?? V_FAILCOUNT
????FROM
????CB_LOGON_CTRL
????WHERE
????LCL_BRANCHID = IN_BRANCHID AND
????LCL_USERID = IN_CSTNO||IN_USERID;
???????????SELECT????????????????????????????????????2?????????????????????????ORA-01403: δ????κ???????????????
???????????SELECT INTO ?????????????????????????????????PL/SQL???е???????????????????????
???????????????????????????????????2?????????
??????????????Oracle????????????????????????????????????????????????
????Oracle?????????
????????????????????Oracle?????????????????????????????
????1??DUP_VAL_ON_INDEX ???? ORA-00001 ??????????в???????
????2??INVALID_CURSOR ???? ORA-01001 ??????з???α????
????3??INVALID_NUMBER ???? ORA-01722 ???????????????????
????4??NO_DATA_FOUND ???? ORA-01403 SELECT INTO ?????????κη?????
????5??TOO_MANY_ROWS ???? ORA-01422 SELECT INTO ????з?????
????6??ZERO_DIVIDE ???? ORA-01476 ?????0???????
????7??CURSOR_ALREADY_OPEN ???? ORA-06511 ????????????????α?
????PL/SQL????EXCEPTION????????????????????????????洢?????????????????????????SQL??
????????????Oracle?е?ROWNUM?????
???????????????У?ROWNUM????????????е????б??????к??????з???1??????з???2...?????????????ROWNUM?????????????????????????????￡?
????SELECT * FROM ENT_ROLE WHERE ROWNUM < 10; --???ENT_ROLE?е??9?????
????ROWNUM??ROWID??????ROWID??????????????????????е?????????ROWNUM??????????????????????????????е????