3 Replies Latest reply: Mar 24, 2013 6:28 AM by Timo Hahn RSS

    createViewObjectFromQueryStmt is not populating any rows

    980655
      Hi,

      My JDeveloper Version 11.1.1.5.

      I have one dynamic view object. I am passing the custom query to this view object through createViewObjectFromQueryStmt("BusinessServiceDependencyReportVO1", sqlStatement) method.

      the parameter "sqlStatement" is taking the my custom sql query correctly. And the createViewObjectFromQueryStmt method is getting Executed with the parameter without any problem... But it is not populating any rows in the table but it should...


      *my custom sql statement returns rows if i execute in sql worksheet.


      Could any one please give me some Idea...

      Thanks IN advance.