What controls automatic recompile of stored procedure
From: Hill, James [MNBL1:9478:EXCH] <jimhill_at_americasm01.nt.com>
Date: Thu, 5 Aug 2004 17:19:43 -0500
Message-ID: <ceubkr$8ag$1_at_zcars0v6.ca.nortel.com>
[Quoted] [Quoted] Is there something that controls the automatic recompiling of stored [Quoted] 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 [Quoted] [Quoted] stored procedure become invalid (that makes sense).
Date: Thu, 5 Aug 2004 17:19:43 -0500
Message-ID: <ceubkr$8ag$1_at_zcars0v6.ca.nortel.com>
[Quoted] [Quoted] Is there something that controls the automatic recompiling of stored [Quoted] 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 [Quoted] [Quoted] stored procedure become invalid (that makes sense).
If I call the procedure using SQLPlus or with a test application using ODBC [Quoted] from Windows, the procedure recompiles as expected and no errors are presented.
[Quoted] 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? Received on Fri Aug 06 2004 - 00:19:43 CEST