Refine search
String sql = "BEGIN INSERT INTO mytable(id, content) VALUES (seq_mytable.NEXTVAL(), ?) RETURNING id INTO ?; END;"; Connection connection = null; CallableStatement statement = null; try { connection = database.getConnection(); statement = connection.prepareCall(sql); statement.setString(1, "test"); statement.registerOutParameter(2, Types.NUMERIC); statement.execute(); int id = statement.getInt(2); // ...
session.doWork(new Work() { public void execute(Connection connection) throws SQLException { CallableStatement call = connection.prepareCall("{ ? = call MYSCHEMA.MYFUNC(?,?) }"); call.registerOutParameter( 1, Types.INTEGER ); // or whatever it is call.setLong(2, id); call.setLong(3, transId); call.execute(); int result = call.getInt(1); // propagate this back to enclosing class } });
CallableStatement proc = connection.prepareCall("{ ? = call dbo.mySproc() }"); proc.registerOutParameter(1, Types.INTEGER); proc.execute(); int returnValue = proc.getInt(1);
jdbcTemplate.execute( new CallableStatementCreator() { public CallableStatement createCallableStatement(Connection con) { CallableStatement cs = con.prepareCall("{? = call MY_FUNCTION(?, ?, ?)}"); cs.registerOutParameter(1, Types.INTEGER); // or whatever type your function returns. // Set your arguments cs.setInt(2, ...); // first argument cs.setInt(3, ...); // second argument cs.setInt(4, ...); // third argument return cs; } }, new CallableStatementCallback { public Object doInCallableStatement(CallableStatement cs) { cs.execute(); int result = cs.getInt(1); return result; // Whatever is returned here is returned from the jdbcTemplate.execute method } } );
cs.registerOutParameter(2, Types.VARCHAR); cs.registerOutParameter(3, OracleTypes.CURSOR); cs.execute();
CallableStatement statement = session.connection().prepareCall( "{ ? = call Transferlocation_Fix(?) }"); statement.registerOutParameter(1, Types.VARCHAR); statement.setString(2, "FC3"); statement.execute(); String result = statement.getString(1);
String procedure = "{? = call CREATE_A_PERSON (?)}"; CallableStatement statement = conn.prepareCall(procedure); statement.registerOutParameter(1, java.sql.Types.STRUCT, "UDO_PERSON"); statement.setString(2, "YOURE NAME"); statement.execute(); ...
CallableStatement c = conn.prepareCall("{? = call get_object_type(?, ?)}"); c.registerOutParameter(1, Types.VARCHAR); c.registerOutParameter(3, Types.VARCHAR); c.setString(2, buffer); c.execute(); String res = c.getString(1); String err = c.getString(3);
CallableStatement proc_stmt = connection.prepareCall(" {? = call F_CHK_PREVIOUSLOAD(?)}"); proc_stmt.registerOutParameter(1, OracleTypes.NUMBER); proc_stmt.setLong(2, Id); proc_stmt.execute(); // ... your succeeding code
CallableStatement stmt = null; String sql = "begin ? := Average(?); end;"; ResultSet rs = null; try { stmt = conn.prepareCall(sql); stmt.registerOutParameter(1, INT); stmt.setString(2, "VALUE"); stmt.execute(); } Catch(){ ....}
String constantValue; CallableStatement statement = connection.prepareCall("BEGIN ? := Package1.A_CONSTANT; END;"); try { statement.registerOutParameter(1, Types.VARCHAR); statement.execute(); constantValue = statement.getString(1); } finally { statement.close(); }
CallableStatement callableStatement = session.connection().prepareCall("call GetMarketDataCDS(?,?)"); callableStatement.setString(1,"JPM"); callableStatement.registerOutParameter(1, OracleTypes.CURSOR); callableStatement.execute(); ResultSet resultSet=(ResultSet) callableStatement.getObject(1);
CallableStatement proc = con.prepareCall("{ ? = call PSSQLPRC(?,?) }"); proc.registerOutParameter(1, Types.NUMERIC); proc.setString(2,"abc"); proc.setInt(3,10); proc.execute();
connection = dataSource.getConnection(); CallableStatement statement = connection.prepareCall("{? = call dbo.RegisterInitAssets(?)}"); statement.registerOutParameter(1, OracleTypes.CURSOR);//you can skip this if procedure won't return anything statement.setObject(2, new InitvalsMsg()); //I hope you some kind of representation of this table in your project statement.execute(); ResultSet set = (ResultSet) statement.getObject(1);//skip it too if its not returning anything
// Turn transactions off. con.setAutoCommit(false); // Procedure call. CallableStatement upperProc = con.prepareCall("{ ? = call upper( ? ) }"); upperProc.registerOutParameter(1, Types.VARCHAR); upperProc.setString(2, "lowercase to uppercase"); upperProc.execute(); String upperCased = upperProc.getString(1); upperProc.close();
try (CallableStatement myFirstCs = conn.prepareCall("{call getSECTION_NAME(?,?)}")) { myFirstCs.setInt(1, 2); // set IN parameter "myID" to value 2 myFirstCs.registerOutParameter(2, Types.VARCHAR); myFirstCs.execute(); String sectionName = myFirstCs.getString(2); // get value from OUT parameter "myName" System.out.println(sectionName); }
CallableStatement stmt = conn.prepareCall("BEGIN getLogs(?, ?, ?); END;"); stmt.setInt(1, 0); stmt.setInt(2, 0); stmt.registerOutParameter(3, OracleTypes.CURSOR); stmt.execute(); ResultSet rs = ((OracleCallableStatement)stmt).getCursor(3); while (rs.next()) { ; //here build your Map, list or whatever you want }
String query = "begin SP_FAM_VOLWEEKLY(CV_1 => ?, p_report_type=> 0, p_type => 2, p_num_week => 5, P_GROUPBY_GROUP => 1, p_groupby_cpty => 0, p_groupby_desk => 0, p_groupby_ccy => 1, p_groupby_t_tz => 1, P_GROUPBY_U_LOCALE => 1); end;"; CallableStatement stmt = conn.prepareCall(query); // register the type of the out param stmt.registerOutParameter(1, OracleTypes.CURSOR); stmt.execute(); ResultSet rs = (ResultSet) stmt.getObject(1); while (rs.next()) { System.out.println(rs.getString("CCY")) }
// Procedure call. CallableStatement proc = conn.prepareCall("{ ? = call refcursorfunc() }"); proc.registerOutParameter(1, Types.OTHER); proc.execute(); ResultSet results = (ResultSet) proc.getObject(1); while (results.next()) { // read results } results.close(); proc.close();
CallableStatement cs = conn.prepareCall("{call demo.run_demo(?,?,?)}"); cs.setString(1, "update demo.users set locale=''english'' where user_id = 2"); cs.registerOutParameter(2, Types.INTEGER); cs.registerOutParameter(3, Types.VARCHAR); cs.execute(); System.out.println("out="+cs.getInt(2) + ":" + cs.getString(3));