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: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 27 Nov 2002 12:21:19 -0000
Message-ID: <3de4b8bf$0$8509$ed9e5944@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:21:19 CST

Original text of this message

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