http://mahmoudoracle.blogspot.com/2012/05/adf-dynamic-view-object.html#.UPh5UB3AfSg
Create a VO with- select * from dual
public void changeDynamicVoQuery(String sqlStatement) {
ViewObject dynamicVO = this.findViewObject("DynamicVO");
dynamicVO.remove();
dynamicVO =
this.createViewObjectFromQueryStmt("DynamicVO", sqlStatement);
dynamicVO.executeQuery();
ViewRowImpl row = (ViewRowImpl)dynamicVO.next();
String count = (String)row.getAttribute(0).toString();
this.setCount(count);
}
Create a VO with- select * from dual
public void changeDynamicVoQuery(String sqlStatement) {
ViewObject dynamicVO = this.findViewObject("DynamicVO");
dynamicVO.remove();
dynamicVO =
this.createViewObjectFromQueryStmt("DynamicVO", sqlStatement);
dynamicVO.executeQuery();
ViewRowImpl row = (ViewRowImpl)dynamicVO.next();
String count = (String)row.getAttribute(0).toString();
this.setCount(count);
}
No comments:
Post a Comment