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