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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-2131 - what does it mean ?

Re: ORA-2131 - what does it mean ?

From: Marcus Miss <marcus.miss_at_innoface.de>
Date: Wed, 27 Nov 2002 13:53:55 +0100
Message-ID: <as2f95$3t9$05$1@news.t-online.com>


I found somewhere a hint that ORA-messages in the range 2100-21xx will map to SQL-21xx-messages.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> schrieb im Newsbeitrag news:3de4b8bf$0$8509$ed9e5944_at_reading.news.pipex.net...
> there isn't a windows equivalent of oerr, though there are various ways to
> simulate it to a greater or lesser degree. Jonathan has one on his site.
>
> how did you know it was SQL-02131 not ORA-02131 by the way.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
> news:E2F6A70FE45242488C865C3BC1245DA702FADD96_at_lnewton.leeds.lfs.co.uk...
> > Hi Marcus,.
> >
> > are you aware of a utility called 'oerr' with which you can interrogate
> > Oracle error messages - and sometimes get more info than in the 3 error
> > manuals. Sometimes less mind you !
> >
> > I'm not sure what the Windows equivalent is though !
> >
> > example :
> >
> > oerr sql 2131
> > 02131, 00000, "Runtime context in use"
> > // *Cause: Your application attempted to execute a SQL statement using a
> > // runtime context that is already in use.
> > // *Action: Rewrite the application to either wait for one thread to
> > complete
> > // before executing another SQL statement with the same runtime
> > // context, or to allocate and use a separate runtime context
> > for
> > // each thread.
> >
> >
> > Cheers,
> > Norman.
> >
> > -------------------------------------
> > Norman Dunbar
> > Database/Unix administrator
> > Lynx Financial Systems Ltd.
> > mailto:Norman.Dunbar_at_LFS.co.uk
> > Tel: 0113 289 6265
> > Fax: 0113 289 3146
> > URL: http://www.Lynx-FS.com
> > -------------------------------------
> >
> > -----Original Message-----
> > From: Marcus Miss [mailto:marcus.miss_at_innoface.de]
> > Posted At: Wednesday, November 27, 2002 9:53 AM
> > Posted To: server
> > Conversation: ORA-2131 - what does it mean ?
> > Subject: Re: ORA-2131 - what does it mean ?
> >
> >
> > I'm one step ahead : Found somewhere a hint that messages in the range
> > "ORA-21xx" refers to "SQl-21xx" and this says
> > "Your application attempted to execute a SQL statement using a runtime
> > context that is already in use.". Seems to be a threading problem !
> >
> > Thanks folks for your help !!
> > Regards,
> > Marcus
> >
> >
>
>
Received on Wed Nov 27 2002 - 06:53:55 CST

Original text of this message

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