APEX

Hello All,

I have a region that is of type "SQL Query". Also in this region is an "Apply Updates" button. There is a page validation that checks for a value in a shuttle which fires when "Apply Updates" is pressed. Sometimes when the button is pressed and the validation fails the region returns the no data found message as defined in the reports attribute page for the region, other times when the validation fails the data that was in the region before the button was pressed just stays there, like it should.

Why am I getting these different results when the validation fails? Why do I sometimes get "no data found" and other times I get the data that is in the table as returned by the SQL Query?

A couple things to point out,

1) The table always has data in it, the sql query will always return row(s)

2) The sql query is NOT dependant on any page level values being set.

3) The sql query is simple, similar to...

select *
from my_custom_table
order by my_column asc