Question

java.lang.Exception: 索引中丢失 IN 或 OUT 参数:: 2这个异常是什么意思，如何解决，请高手指点！

java.lang.Exception: 索引中丢失 IN 或 OUT 参数:: 2
atcom.easymap.management.apiimpl.OrganizationManagerImpl.findOrganizationsByLevel(Unknown Source)
at test.Test_OrganizationManager.testfindOrganizationsByLevel(Test_OrganizationManager.java:22)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at junit.framework.TestCase.runTest(TestCase.java:168)
at junit.framework.TestCase.runBare(TestCase.java:134)
at junit.framework.TestResult$1.protect(TestResult.java:110)
at junit.framework.TestResult.runProtected(TestResult.java:128)
at junit.framework.TestResult.run(TestResult.java:113)
at junit.framework.TestCase.run(TestCase.java:124)
at junit.framework.TestSuite.runTest(TestSuite.java:232)
at junit.framework.TestSuite.run(TestSuite.java:227)
at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:76)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

Answer 1

sql语句中设置参数的时候参数位置出了错，或者参数不够。认真检查，一遍不行两遍

追问

SELECT
T1.ZZJGDM,T1.ZZJGMC,T1.PYJS,T2.JGLXDM,T2.JGLXMC,T2.PARENT,T1.ZXX,T1.ZXY,T1.FDJB,T1.SFYX,T1.SSJGDM,T1.JXPY,T1.SSTCMC,T1.ZZJGQC,T1.NO,T1.PPFIELD,T1.JGLX,T1.PXFIELD,T1.BJZBZ,T1.REMARK FROM (SELECT T.*, LEVEL LEV FROM T_ZZJG T CONNECT BY T.SSJGDM = PRIOR T.ZZJGDM START WITH T.SSJGDM IS NULL) T1,D_ZZJGLX T2 WHERE T1.ZZJGLX= T2.JGLXDM AND T1.LEV=?;你能看出这段sql语句错哪了么

追答

直接在sqlplus中可以执行吗？