Question

jdbc报的一个Exception in thread "main" java.sql.SQLException: ORA-06550: 第 1 行, 第 7 列:

import java.sql.*;
public class TestProc {

public static void main(String args[]) throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
//new oracle.jdbc.driver.OracleDriver();
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","zwb123");
CallableStatement cstmt = conn.prepareCall("{call p(?, ?, ?, ?)}");
cstmt.registerOutParameter(3, Types.INTEGER);
cstmt.registerOutParameter(4, Types.INTEGER);
cstmt.setInt(1, 3);
cstmt.setInt(2, 4);
//cstmt.setInt(3, 6);
cstmt.setInt(4, 5);
cstmt.execute();
System.out.println(cstmt.getInt(3));
System.out.println(cstmt.getInt(4));
cstmt.close();
conn.close();
}
}

Exception in thread "main" java.sql.SQLException: ORA-06550: 第 1 行, 第 7 列:
PLS-00306: 调用 'P' 时参数个数或类型错误
ORA-06550: 第 1 行, 第 7 列:到底哪里不对了

Answer 1

把你的 存储过程代码贴出来看看啊

Answer 2

过程是4个参数,但是你只设置了3个

Answer 3

存储过程拿出来看看了！拿出来给你测试一下

Answer 4

那要看你的P存储过程是如何写的了。