Oracle OAF: Copy files to application server

Here is how different files are copied to the application server:- Controller files (CO.class):    go from /myclasses/.../webui to $JAVA_TOP/.../webui- View Object files (VO.xml, VOImpl.class, VORowImpl.class):    go from /myclasses/.../server to $JAVA_TOP/.../server-…

Continue ReadingOracle OAF: Copy files to application server

Oracle OAF: Display messages

Here are some examples from OAF types of messages:Debug Message:pageContext.writeDiagnostics(this, "CustomDebug message: milestone 01", OAFwkConstants.PROCEDURE);(Can be viewed with Diagnostics enabled on PROCEDURE level)Error Message:throw new OAException("XXX", "XXX_MY_CUSTOM_MSG", null, OAException.ERROR, null);Confirmation…

Continue ReadingOracle OAF: Display messages

Oracle OAF: Loop through a VO

The following piece of code is an example of how we can loop a View Object (VO) and do something:   public void processFormRequest(OAPageContext pageContext,                               OAWebBean oawebbean) {                                         super.processFormRequest(pageContext, oawebbean);  …

Continue ReadingOracle OAF: Loop through a VO

Oracle OAF: Forward to a new page

This code requires you to setup a new function with name XXX_CUSTOM_PAGE, specify the complete path and assign this function to your responsibility.String AuctionHeaderId = ReqRow.getAttribute("AuctionHeaderId").toString();String BidNumber = ReqRow.getAttribute("BidNumber").toString();HashMap hm…

Continue ReadingOracle OAF: Forward to a new page

Oracle OAF: Call Procedures and Functions

Call Procedure in OAF (1 input, 1 output parameter):            String sql = "BEGIN xx_custom_pkg.custom_prc (:1,:2); END;";             try {                OracleCallableStatement cs =                    (OracleCallableStatement)oam.getOADBTransaction().createCallableStatement(sql,                                                                                              2);                 ((OracleCallableStatement)cs.registerOutParameter(2,                                                                  Types.VARCHAR,                                                                  0, 2000));                 cs.setString(1, xxAttribute1Value);                cs.execute();               …

Continue ReadingOracle OAF: Call Procedures and Functions