data not refreshing or give 0 observation though table has data

[jainmo]

I am working with oracle view. when I open view in toad or developer have to refresh it twice ot thrice to see data.

In my sas code, I have automate the code bu now for last 2 -3 week its not getting refresh. I did create do loop but still not get result. I included this dataset becuase earlier I was getting 0 observation but then when I did this it worked but now suddenly getting 0 observation.

ex 

data x;

set t;

do i=1to 5;

output;end;

run;

proc sql;

create table t as 

select * from x;

quit;

[SASKiwi]

Please post the complete SAS log of your program reading the Oracle data. The code you have posted doesn't read Oracle at all.

[Patrick]

From what you describe and given you've also observed similar behavior when using toad or SQL Developer this feels very much not like a SAS issue but something to be solved on the DB side. If you can't investigate yourself then you need eventually to talk to a Oracle DBA.

I've worked with Oracle before but a view that needs multiple refreshes until it returns the expected data is nothing I've ever encountered. 

Is this a "normal" view or by any chance a materialized view?