ORA-2131 - what does it mean ?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 27 Nov 2002 10:12:27 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702FADD96@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 - 04:12:27 CST