Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Wednesday, May 22, 2013

ORA-02114 - Undocumented error

One of the developer on client side got the error, ORA-02114.

after research I found below.

ora-2114 error is not documented anywhere that can be found. Looked in manuals
including the language ones and oerr on 7.1.3 and 7.0.16. The error is
described as follows (in Techrep and bug#199380.):
ORA-2114 Attempting to close an already closed cursor..

Message 2114 is documented in the Oracle7 Server Messages and Codes Manual,
page 4-54, where it appears as SQL-2114.

Error:  SQL 2114 
Text:   Invalid SQL Cursor usage: trying to close a closed cursor 
Cause:  You tried to CLOSE a never OPENed or already CLOSEd cursor or you 
        misspelled the cursor name. Only a currently open cursor can be CLOSEd.
Action: Check your spelling of the cursor name and check that the cursor is 
        open before you try to CLOSE it

No comments: