Re: help!! how to call pl/sql anonymous block from java?

code schrieb:
> I know that jdbc can call a pl/sql package or procedure,but if i
> want to call a pl/sql anonymous block, how can i do it? no procedure
> name or package name will be offered.
> Can u give me a sample code? thanks very much
Here we go:

import java.sql.*;

public class JP {

    public static void main(String[] args) {

       try {
          Class.forName(oracle.jdbc.driver.OracleDriver.class.getName());
       } catch(ClassNotFoundException ex) {
          ex.printStackTrace();
       }

       String oraUser = args[0];
       String oraPwd = args[1];
       try {
          Connection conn = 
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE",
                                                        oraUser,
                                                        oraPwd);
          conn.setAutoCommit(false);
          String plsql = "BEGIN INSERT INTO t VALUES(42); COMMIT; END;";
          PreparedStatement statement = conn.prepareStatement(plsql);
          statement.execute();
       } catch(SQLException ex) {
          ex.printStackTrace();
       }

    }
}

hth,
Urs Metzger Received on Sat Mar 29 2008 - 05:14:34 CDT