This discussion is archived
3 Replies Latest reply: Mar 24, 2013 4:28 AM by Timo Hahn RSS

createViewObjectFromQueryStmt is not populating any rows

980655 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points