Re: What controls automatic recompile of stored procedure

Hill, James [MNBL1:9478:EXCH] wrote:
> Is there something that controls the automatic recompiling of stored
> procedures? I have a stored procedure that is dependent on some tables that
> are replicated from a remote database. Whenever the table is changed, the
> stored procedure become invalid (that makes sense).
>
> If I call the procedure using SQLPlus or with a test application using ODBC
> from Windows, the procedure recompiles as expected and no errors are
> presented.
>
> But when I call the procedure from a UNIX client using the OpenLink UDBC
> library, it fails and gives me the error ORA-04043: Object PROC does not
> exist.
>
> Is there something that needs to be set at the session or something else
> that need to set the default to auto-recompile?
>
>

Oracle has "implicit run-time recompilation", as your SQL*Plus and ODBC tests confirm. What version and platform are your database and client running on? Perhaps the "OpenLink UDBC library" is an unsupported client version for the database your are running. You could always explicitly compile everything after your replication, too.

--Mark Bole Received on Fri Aug 06 2004 - 02:36:34 CEST