Refreshing Materialzed Views from APEX not working
tillieJan 30 2013 — edited Feb 4 2013We have a stored procedure which is being executed from APEX, the stored procedure refreshes a couple materialized views. When we execute the stored procedure from SQL Developer, as the schema owner, the materialized views are updated correctly. Correct data and refresh datetime change as expected. Also all is correct if we refresh each materialized view manually.
Here is the weird thing that happens, when we execute that same stored procedure, but this time from APEX, it appears that the materialized view is refreshed, but now it has records missing. The refresh datetime is correct, but the data is wrong.
We are using APEX 4.1.1.00.23, and an 11.2.0.3.0 database.
Any suggestions of things to try would be great.