stmt_call= conn.prepareCall("{ ? = call " + sql + "}");
stmt_call.registerOutParameter(1, OracleTypes.CURSOR);
stmt_call.execute();
rs= (ResultSet) stmt_call.getObject(1);
这是接收过程,sql是procname(var1,var2)之类的东东
stmt_call.registerOutParameter(1, OracleTypes.CURSOR);
stmt_call.execute();
rs= (ResultSet) stmt_call.getObject(1);
这是接收过程,sql是procname(var1,var2)之类的东东
SELECT * FROM zte_werp_oracle where enabled_flag= 'Y' and werp_id > 100 ORDER BY WERP_ID;
让它变成动态SQL且能执行.