Thursday, October 15, 2015

How to Create View Object Dynamically

1.   Create Sql Statement in variable:-

String sqlStatement1;
                sqlStatement1 = " SELECT JEG_PA_REGREC_BRATE_BILL_TYPE('"+pptype+"','COLUMN1'"+") FROM DUAL " ;

2.   Check View object is exists or not if exist then remove and Create and execute like following code


OAApplicationModule am = pageContext.getApplicationModule(webBean);

                              if(am.findViewObject("getsqlStatement1VO") != null)
                               {
                                 am.findViewObject("getsqlStatement1VO").remove();
                               }
                      ViewObject getsqlStatement1VO = am.createViewObjectFromQueryStmt("getsqlStatement1VO", sqlStatement1);

                      getsqlStatement1VO.executeQuery();

No comments:

Post a Comment