Re: ora-4063

  • From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
  • To: genegurevich@xxxxxxxxxxxx
  • Date: Wed, 1 Oct 2008 09:04:59 -0500

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.'

Other related posts: