Re: package compilation hangs
- From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 Aug 2004 16:53:56 -0400
Hi, there is a bug on 9.2 if for example some one is connected from Oracle
forms, and compiled a form that used a function,
you can't replace that function until the form users disconnect.
hope this help.
Juan Carlos Reyes Pacheco
OCP
-------Original Message-------
From: oracle-l@xxxxxxxxxxxxx
Date: 08/31/04 16:06:20
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: package compilation hangs
Govindan,
Thanks for ur response.
We do user JDBC OCI driver (froma ppserver ) to access this PL/SQL package.
As you mentioned that Java application might have accessed this package
while compiling this package.
This particular session (SID=667) is active(checked gv$session).
How to fix this?
----- Original Message -----
From: GovindanK <gkatteri@xxxxxxxxxxx>
Date: Tuesday, August 31, 2004 4:02 pm
Subject: Re: package compilation hangs
> That means there is some active session which is holding the
> package in
> memory and has not released it.
> Check from v$session for active sessions. We run into this frequently
> in development though not in production. The developers here use JDBC
> drivers and when a pkg.is being recompiled by the pl/sql developer and
> simultaneously accessed by the JDBC this occurs. Check if you are
> running into any similar env
>
> HTH
> GovindanK
>
>
> On Tue, 31 Aug 2004 15:49:14 -0400, jaysingh1@xxxxxxxxxxxxx said:
> > Hi All,
> >
> > The package BODY status became invalid because of the object
> > modification(another package) refered in the package body.
> >
> > Now we are trying to compile the package and it hangs.
> >
> > Checked DBA_DDL_LOCKS
> > select owner,session_id,mode_held from dba_ddl_locks where
> > name='SEARCH_PKG';
> >
> > OWNER,SESSION_ID,MODE_HELD
> > ----- ---------- ----------
> > REPORTS,667,Share
> > PUBLIC,667,Share
> > ATG56,667,Share
> > REPORTS,667,None
> > REPORTS,968,Exclusive
> >
> >
> > If I kill session_id 968, something else appears here. I did this
> > exercise 4 times.
> > What could be wrong here.
> >
> >
> > select * from gv$access where object='SEARCH_PKG' is returning
> more than
> > 50 records.
> >
> > Could someone shed some light on this?
> >
> > Thanks
> > Jay
> >
> >
> >
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
