Create a run time VO in OA framework
To create a run time VO you have to follow these steps which are given below:
OAApplicationModule am = pageContext.getApplicationModule(webBean);
OADBTransaction oadbtransaction = am.getOADBTransaction();
String validateStr1 = "select column_name from table_name where column_name = :1";
ViewObject validateViewObject1 = (ViewObject)am.findViewObject("ValidateCodeVO1");
if (validateViewObject1 == null)
validateViewObject1 = (ViewObject)am.createViewObjectFromQueryStmt("ValidateCodeVO1", validateStr1);
validateViewObject1 = (ViewObject)am.findViewObject("ValidateCodeVO1");
if (validateViewObject1 != null)
{
validateViewObject1.setWhereClause(null);
validateViewObject1.setWhereClauseParam(0, pageContext.getParameter("NtfId"));
validateViewObject1.executeQuery();
validateViewObject1.reset();
oracle.jbo.Row validaterow = validateViewObject1.first();
if (validaterow != null)
message_type = validaterow.getAttribute(0).toString();
}
OAApplicationModule am = pageContext.getApplicationModule(webBean);
OADBTransaction oadbtransaction = am.getOADBTransaction();
String validateStr1 = "select column_name from table_name where column_name = :1";
ViewObject validateViewObject1 = (ViewObject)am.findViewObject("ValidateCodeVO1");
if (validateViewObject1 == null)
validateViewObject1 = (ViewObject)am.createViewObjectFromQueryStmt("ValidateCodeVO1", validateStr1);
validateViewObject1 = (ViewObject)am.findViewObject("ValidateCodeVO1");
if (validateViewObject1 != null)
{
validateViewObject1.setWhereClause(null);
validateViewObject1.setWhereClauseParam(0, pageContext.getParameter("NtfId"));
validateViewObject1.executeQuery();
validateViewObject1.reset();
oracle.jbo.Row validaterow = validateViewObject1.first();
if (validaterow != null)
message_type = validaterow.getAttribute(0).toString();
}
Some Other Most Useful OAF Tutorials:
- How To Call A Concurrent Program From OA Framework Pages
- How To Call A PL/SQL Procedure From An OAF Page
- How To Change The Header Of An Advance Table Column Dynamically
- How To Create A Submit Button Dynamically In OAF Page
- How To Implement Train In OAF | Implementation Of Train Functionality In OAF
- How To Import Oaf Pages From Unix Server Or Apps server.
- Implement PopList in OA Framework | OAF Tutorials
- Implementation of PPR [Partial Page Rendering] in OAF Page
- OA Framework Interview Questions And Answers - Part1
- VO Extension In OAF | Hiding An Item Conditionally Through SPEL In OAF
COMMENTS