How To Create A VO At Run Time In OA framework

 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();
} 

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