我在执行过程调用函数时报错:ORA-06502: PL/SQL:数字或值错误 : 数值精度太高
部分代码:
function checkOrgunitInfo(organise_name in varchar2,
organise_type in
varchar2,
insure_flag in
varchar2,
father_id in
varchar2,
regin_no in
varchar2,
解决方法:找到服务器下的 right9_jsp.java 文件,打开找到449行
是截取字符串时出错了,原因可能是字符串为空,或长度不足3
16:56:45,687 ERROR [[jsp]] Servlet.service() for servlet jsp
threw exception
java.lang.StringIndexOutOfBoundsException: String index out of
range: -3
at java.lang.String.substring(String.java:1768)
at
org.apache.jsp.cms.right9_jsp._jspService(right9_jsp.java:449)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)