Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Fwd: RE: Locking issue

Re: Fwd: RE: Locking issue

From: <Jared.Still_at_radisys.com>
Date: Tue, 04 Sep 2001 09:49:36 -0700
Message-ID: <F001.0038203D.20010904095028@fatcity.com>

Ivo,

I can't find a reference to any 'ORU' errors in the docs or on MetaLink.

Since it was reported via raise_application_error(), I still think you should look at the code, if available.

If the code is not available, open an iTar at MetaLink, unless someone else on the list can tell you what this is.

Jared

                                                                                       
                             
                                                                                       
                             
                                         To:     jared_still_at_radisys.com               
                             
                                         cc:                                           
                             
                                         Subject:     Fwd: RE: Locking issue           
                             
                                                                                       
                             






The error is raised inside DBS_ALERT package (wrapped). I would like to know
what can cause the "ORU-10001: lock request error, status: 2 " error message
when
using dbms_alert?
Could it be a problem of insufficient resources / dml_locks? Thank you for responce
Ivo

-----Original Message-----
Sent: Tuesday, September 04, 2001 05:31 PM To: ORACLE-L_at_fatcity.com; Libal, Ivo

ORA-20000 is an error raised by raise_application_error.

In other words, you must examine the code, as it is a custom error message.

Jared

On Tuesday 04 September 2001 07:25, Libal, Ivo wrote:
> Hello All
> we got a problem with DBMS_ALERT package. On clients we get sometimes an
> error message:
> ORA-20000: ORU-10001: lock request error, status: 2
> Where can be a problem? Is it a problem of ENQUEUE_RESOURCES or DML_LOCKS
> parameters?
> How can I check it?
> Thank you for any responce
> Regards
> Ivo Libal


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Sep 04 2001 - 11:49:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US