What user is executing the batch job, and does it have alter privileges on the views (as in alter view compile?) On Wed, Oct 1, 2008 at 8:56 AM, <genegurevich@xxxxxxxxxxxx> wrote: > Hello everybody: > > I am running oracle 10.2.0.1 In the database schema1 owns several tables > and select on these tables is granted to > public. Schema2 owns several views using the tables in schema1. Select on > these views is also granted to > public. And I have a schema3 which runs selects against schema2's views > from a Pro*C code. > > Once every 2 weeks, all objects in schema1 are being dropped and reimported > (without structure changes, just > with different data). After that all the views in the schema2 become > invalid. This does not seem to be an issue > because a desc or select command runs successfully and changes the status > to valid. This however does not > seem to be the case with the Pro*C code which fails consistently with > ORA-4063. The command that fails > is select col into variable from view . When I run this command manually > from SQL> prompt, I have no issues, > when it is executed in batch mode from Pro*C script it fails > > Has anyone seen this issue before and what could be the fix for it? > > thank you > > Gene Gurevich > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'