（import java.sql.CallableStatement;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Types;包是ojdbc6.jar或classes12.jar        ）public static void main(String[] args) throws Exception {        Class.forName("oracle.jdbc.driver.OracleDriver");        Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","name","password");                 //调用存储过程的格式("{ call HYQ.TESTA(?,?) }")        CallableStatement callableStatement = connection.prepareCall("{ call SH_VEH_CX(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) }");        callableStatement.setString(1, "vhpzl");//输入参数        callableStatement.setString(2, "vhphm");                 callableStatement.registerOutParameter(3, Types.VARCHAR);//输出参数        callableStatement.registerOutParameter(4, Types.VARCHAR);        callableStatement.registerOutParameter(5, Types.VARCHAR);        callableStatement.registerOutParameter(6, Types.VARCHAR);        callableStatement.registerOutParameter(7, Types.VARCHAR);        callableStatement.registerOutParameter(8, Types.VARCHAR);        callableStatement.registerOutParameter(9, Types.VARCHAR);        callableStatement.registerOutParameter(10, Types.VARCHAR);        callableStatement.registerOutParameter(11, Types.VARCHAR);        callableStatement.registerOutParameter(12, Types.DATE);        callableStatement.registerOutParameter(13, Types.DATE);        callableStatement.registerOutParameter(14, Types.DATE);        callableStatement.registerOutParameter(15, Types.VARCHAR);        callableStatement.registerOutParameter(16, Types.VARCHAR);                 callableStatement.execute();//执行存储过程         String vRES = callableStatement.getString(3);//获取输出参数        String VCLSBDH = callableStatement.getString(4);        String VFDJH = callableStatement.getString(5);        String VCLLX = callableStatement.getString(6);        String VCSYS = callableStatement.getString(7);        String Vsyxz = callableStatement.getString(8);        String VSFZMHM = callableStatement.getString(9);        String VSYR = callableStatement.getString(10);        String Vsyq = callableStatement.getString(11);        String Vccdjrq = callableStatement.getString(12);        String Vyxqz = callableStatement.getString(13);        String Vqzbfqz = callableStatement.getString(14);        String Vzt = callableStatement.getString(15);        String Vsjhm = callableStatement.getString(16);    }

转自：