Thursday, January 17, 2013

DynamicVO - Executes DynamicSQL Query

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

    }

No comments: