From: <genegurevich_at_discover.com>
Date: Wed, 1 Oct 2008 08:56:07 -0500
Message-ID: <OF207EFC16.70FD1CF2-ON862574D5.004BF24D-862574D5.004C8E53@discover.com>

Hello everybody:

I am running oracle 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

Received on Wed Oct 01 2008 - 08:56:07 CDT

Original text of this message