Hi All,
I am trying to execute stored procedure using JDBC. I am trying following code.
When i run this code it gives me following error at line storedQuery.setString("name1","my_name");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"); }
Code: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)




Reply With Quote