public static final void doCall(
java.sql.Connection db, String cmd, VariableTable vt, DBCommandHandler cmdhandler) {
int rows = 0;
int rowcount = -1;
boolean resultreturned = false;
java.sql.ResultSet rset = null;
SQLCallable pstmt = null;
try {
pstmt = DBOperation.prepareCall(db, cmd, vt);
if (pstmt.stmt == null) return;
pstmt.bind(vt);
resultreturned = pstmt.stmt.execute();
pstmt.fetch(vt);
do {
if (resultreturned) {
rset = pstmt.stmt.getResultSet();
cmdhandler.showResultSet(rset);
rset.close();
} else {
try {
rowcount = pstmt.stmt.getUpdateCount();
} catch (java.sql.SQLException e) {
rowcount = -1;
}
if (rowcount >= 0) {
cmdhandler.showMessage(rowcount);
}
}
resultreturned = pstmt.stmt.getMoreResults();
} while (resultreturned || rowcount != -1);
} catch (java.sql.SQLException sqle) {
cmdhandler.showSQLException(sqle);
} finally {
if (pstmt != null && pstmt.stmt != null) {
try {
pstmt.stmt.close();
} catch (java.sql.SQLException e) {
}
}
}
clearWarnings(db, cmdhandler);
}
