By using below script we can perform ddl statement in Application Module.

public void OTCancel() {
OnetimeVOImpl delvo = getOnetimeVO1();
Row row[] = delvo.getAllRowsInRange();
OADBTransactionImpl oadbtransactionimpl =
(OADBTransactionImpl)getDBTransaction();
for (int i = 0; i < row.length; i++) {
OnetimeVORowImpl rowi = (OnetimeVORowImpl)row[i];
if (rowi.getCheckAttr() != null &&
rowi.getCheckAttr().equals(“Y”)) {
try {
String ddl_stmt =
“UPDATE CUSTOM_TAB SET CANCEL_FLAG = ‘Y’,CANCEL_DATE = SYSDATE WHERE REQUEST_ID = ” +
rowi.getRequestId().toString();
ddl_stmt =
ddl_stmt + ” AND ID = ” + rowi.getId().toString();
System.out.println(“Statement > ” + ddl_stmt);
OracleCallableStatement stmt =
(OracleCallableStatement)oadbtransactionimpl.createCallableStatement(ddl_stmt,
-1);
stmt.executeUpdate();

} catch (Exception e) {
throw OAException.wrapperException(e);
}
}
}
getOADBTransaction().commit();
}

Recent Posts

Start typing and press Enter to search