Jdbc

[@tul]

Hi All,

I am trying to execute stored procedure using JDBC. I am trying following code.


// Creating stored procedure
String createProcedure = "create or replace procedure UPDATE_EMPLOYEE( name1 in varchar ) "
+ "as " + "begin " + "update employee set name= name1; " + "end;";

// storing it in the database.
db_statement.execute(createProcedure);

CallableStatement storedQuery = db_connection
.prepareCall("{call UPDATE_EMPLOYEE()}");

// setting input parameter
storedQuery.setString("name1", "my_name");

if (storedQuery.execute()) {
System.out.println("updated table");
}



When i run this code it gives me following error at line storedQuery.setString("name1","my_name");



Exception in thread "main" java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:690)
at oracle.jdbc.driver.OracleCallableStatement.setString(OracleCallableStatement.java:1346)
at Jdbc.main(Jdbc.java:72)