Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ORA-2131 - what does it mean ?

838 views
Skip to first unread message

Marcus Miss

unread,
Nov 27, 2002, 3:27:52 AM11/27/02
to
Hi,
sometimes I get the error ORA-2131, what does this error mean (Running
Oracle 8.1.7.2.1).

Thanks,
Marcus


Howard J. Rogers

unread,
Nov 27, 2002, 3:47:58 AM11/27/02
to
What does the error *text* state?

(it's possible to look up any error number on the Oracle website, but the
number of people who post here thinking that the regulars know all Oracle
error numbers and their associated messages backwards means I'd be forever
doing so if I gave in. My students can't have mobile phones on in the
classroom... and I don't give answers without complete error texts. Just two
simple rules of life, really).

No doubt someone else will be more obliging.

But as a general rule of thumb: oracle version (which you got), platform
(which you didn't) and complete error text (ditto). Then help comes thick
and fast.

Regards
HJR

"Marcus Miss" <marcu...@innoface.de> wrote in message
news:as1vm9$3p4$02$1...@news.t-online.com...

Marcus Miss

unread,
Nov 27, 2002, 4:07:45 AM11/27/02
to
Hi Howard,
Oracle is running under (W2K). I'm not able to deliver the error-message
because the application using Oracle (named Pro/Intralink) just delivers the
error-code. Pro/Intralink fails also on recovering the message.

Thanks,
Marcus

"Howard J. Rogers" <howard...@yahoo.com.au> schrieb im Newsbeitrag
news:ww%E9.84748$g9.2...@newsfeeds.bigpond.com...

Marcus Miss

unread,
Nov 27, 2002, 4:26:46 AM11/27/02
to
Hi,
I found the message but it doesn't help me a lot:
"ORA-02131 Runtime context in use"
Please, can somebody help me ?
Thanks,
Marcus

"Marcus Miss" <marcu...@innoface.de> schrieb im Newsbeitrag
news:as2212$ng8$05$1...@news.t-online.com...

Niall Litchfield

unread,
Nov 27, 2002, 4:38:05 AM11/27/02
to
According to tahiti there is no error ora-2131, nor is there the more likely
ora-02131. Are you sure there isn't a typo in the error number.


--
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

******************************************


"Marcus Miss" <marcu...@innoface.de> wrote in message

news:as2212$ng8$05$1...@news.t-online.com...

Marcus Miss

unread,
Nov 27, 2002, 4:42:09 AM11/27/02
to
Yes, I'm sure : 2131.

"Niall Litchfield" <n-litc...@audit-commission.gov.uk> schrieb im
Newsbeitrag news:3de4927f$0$8510$ed9e...@reading.news.pipex.net...

Marcus Miss

unread,
Nov 27, 2002, 4:53:08 AM11/27/02
to
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

"Marcus Miss" <marcu...@innoface.de> schrieb im Newsbeitrag

news:as241i$5ra$03$1...@news.t-online.com...

Norman Dunbar

unread,
Nov 27, 2002, 5:12:27 AM11/27/02
to
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...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Marcus Miss

unread,
Nov 27, 2002, 5:13:42 AM11/27/02
to
My problem is solved (not really solved but now I know the reason):
Threading problem in Intralink with Pro*C.

Thanks,
Marcus

"Marcus Miss" <marcu...@innoface.de> schrieb im Newsbeitrag

news:as24m6$5ik$01$1...@news.t-online.com...

Niall Litchfield

unread,
Nov 27, 2002, 7:21:19 AM11/27/02
to
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...@lfs.co.uk> wrote in message
news:E2F6A70FE45242488C86...@lnewton.leeds.lfs.co.uk...

Marcus Miss

unread,
Nov 27, 2002, 7:53:55 AM11/27/02
to
I found somewhere a hint that ORA-messages in the range 2100-21xx will map
to SQL-21xx-messages.

"Niall Litchfield" <n-litc...@audit-commission.gov.uk> schrieb im

Newsbeitrag news:3de4b8bf$0$8509$ed9e...@reading.news.pipex.net...

Norman Dunbar

unread,
Nov 27, 2002, 8:47:34 AM11/27/02
to
Hi Niall,

thanks for that snippet - no oerr in Windows.

I knew it was SQL-2131 because the OP said so - plus in my 806 manuals
(paper, lovely paper) it mentions that some ORA error codes are mapped
onto SQL/EXP/etc codes instead.

Regards,
Norman.

-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------


-----Original Message-----
From: Niall Litchfield [mailto:n-litc...@audit-commission.gov.uk]
Posted At: Wednesday, November 27, 2002 12:21 PM
Posted To: server
Conversation: ORA-2131 - what does it mean ?
Subject: Re: ORA-2131 - what does it mean ?

Niall Litchfield

unread,
Nov 27, 2002, 9:14:49 AM11/27/02
to
"Norman Dunbar" <Norman...@lfs.co.uk> wrote in message
news:E2F6A70FE45242488C86...@lnewton.leeds.lfs.co.uk...
> Hi Niall,
>
> thanks for that snippet - no oerr in Windows.
>
> I knew it was SQL-2131 because the OP said so - plus in my 806 manuals
> (paper, lovely paper) it mentions that some ORA error codes are mapped
> onto SQL/EXP/etc codes instead.
>
> Regards,
> Norman.

You mean you read the whole therad before jumping in with a question already
answered in an earlier post. You won't catch me doing that :(. Er i mean
sorry for the daft question as Marcus Miss did indeed say that *and* before
I asked the question. I have no excuse. I'll get me coat.

Galen Boyer

unread,
Nov 27, 2002, 10:26:35 AM11/27/02
to
On Wed, 27 Nov 2002, howard...@yahoo.com.au wrote:
> What does the error *text* state?
>
> (it's possible to look up any error number on the Oracle
> website, but the number of people who post here thinking that
> the regulars know all Oracle error numbers and their associated
> messages backwards means I'd be forever doing so if I gave
> in. My students can't have mobile phones on in the
> classroom... and I don't give answers without complete error
> texts. Just two simple rules of life, really).
>
> No doubt someone else will be more obliging.

I tried to show this guy how simple it was by going to the online
resource for errors, but it wasn't listed.

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76999/e2100.htm#1656

What's up wid dat?
--
Galen Boyer

Niall Litchfield

unread,
Nov 27, 2002, 10:37:23 AM11/27/02
to
see my correspondence with Norman and Marcus. its SQL-02131 not ORA-02131


--
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

******************************************
"Galen Boyer" <galen...@hotpop.com> wrote in message
news:u3cpnm...@standardandpoors.com...

Galen Boyer

unread,
Nov 27, 2002, 10:36:11 AM11/27/02
to
On 27 Nov 2002, galen...@hotpop.com wrote:

> What's up wid dat?

Obviously, I didn't get to the bottom of the thread. :-(
--
Galen Boyer

Paul Brewer

unread,
Nov 28, 2002, 4:08:58 PM11/28/02
to
"Norman Dunbar" <Norman...@lfs.co.uk> wrote in message
news:E2F6A70FE45242488C86...@lnewton.leeds.lfs.co.uk...
> Hi Niall,
>
> thanks for that snippet - no oerr in Windows.
>
> I knew it was SQL-2131 because the OP said so - plus in my 806 manuals
> (paper, lovely paper) it mentions that some ORA error codes are mapped
> onto SQL/EXP/etc codes instead.
>
> Regards,
> Norman.
>
Right enough. Some of the TNS errors do that too. It's mentioned in the 817
html doco as well.

Regards,
Paul

And, just for Norman, because otherwise all this would be a tad too
sensible:
Regrads (:D

0 new messages