java代码部分
public class Test {    /**
     * @param args
     */
    public static void main(String[] args) {
        Connection myConnSDB = null;
        
        //qidong Oracle JDBC Driver 
        try {
            DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
            myConnSDB = DriverManager.getConnection(
                    "jdbc:oracle:thin:@192.168.46.225:1521:ORCL", "NM", "NM");            myConnSDB.setAutoCommit(true);        } catch (SQLException e) {
            e.printStackTrace();
        }        try {
            
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            
            Connection conn = DriverManager.getConnection("jdbc:odbc:TestData", "",
                    "");
            Statement st = conn.createStatement();
            //congwenjianzhongqudeshuju
            ResultSet rs = st.executeQuery("SELECT * FROM [InsertAction$]");
            
                        CallableStatement csInsertData = conn.prepareCall("{ call INSERTDEPT(?,?,?)}");
            while (rs.next()) {
                      
                csInsertData.setString(1, rs.getString(1));
                csInsertData.setString(2, rs.getString(2));
                csInsertData.setString(3, rs.getString(3));
                csInsertData.execute();
                
           }  
            System.out.println("a");
            st.close();
            conn.close();
        } catch (Exception ex) {
            System.err.println("Exception: ");
            ex.printStackTrace();
        } finally {
            try {              
                if (myConnSDB != null) {
                    myConnSDB.close();
                }            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}
Oracle存储过程部分
CREATE OR REPLACE PROCEDURE insertDEPT(v_deptno in dept.deptno%TYPE,v_dname in dept.dname%TYPE,v_loc in dept.loc%TYPE)
AS
   empno_remaining EXCEPTION;
   PRAGMA EXCEPTION_INIT(empno_remaining, -1);
BEGIN
   INSERT INTO dept(deptno,dname,loc)
    VALUES(v_deptno, v_dname, v_loc);
   DBMS_OUTPUT.PUT_LINE('insert success');
EXCEPTION
   WHEN empno_remaining THEN
      DBMS_OUTPUT.PUT_LINE('cuowu');
   WHEN OTHERS THEN
      DBMS_OUTPUT.PUT_LINE(SQLCODE||'---'||SQLERRM);
END InsertDEPT;现在无法把获得的数据写入到数据库中,请高人指点