connecting java with plsql

[arockia rajkumar]

How to call/connect a plsql block with java. can any one know this.please send me with sample coding.

[Bob Rocks]

Are you trying to run a procedure?

            String sp =  "{call procedure()}";
 
            CallableStatement cs = connection.prepareCall(sp);
            ResultSet rs = cs.executeQuery();

hope this helps!