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: Oracle 9i PL/SQL Cursors and Joins

Re: Oracle 9i PL/SQL Cursors and Joins

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Tue, 14 Jan 2003 20:31:11 +0300
Message-ID: <b01hgt$36n$1@babylon.agtel.net>


What's exact Oracle version number? Did you try to apply the latest patch set? If you're on 9.2, please note that 9.2.0.2 patch set is mandatory if you're using XDB or Streams features. If you have the latest patch set installed and still receive this error, it's time to open a TAR with OSS and have them fix this bug (though if you don't have the latest patch set in place, try applying it first as it may have a fix for this particular bug already...) My quick search on ML revealed reference to bug #1937751 with exactly the same symptoms, and it is related to nested cursors. This bug is said to have been fixed in 9.0.2 (read, 9.2). There's also bug #2225569 fixed in 9.0.1.4 and 9.2.0.2, which mentions ORA-600 [kokbnp2] when parsing CURSOR() expression...
Anyway, with ORA-600 your best bet is applying the latest patch set for your version and platform first, confirming that the problem is still there and opening a TAR with OSS if it is. They will probably want trace files generated when ORA-600 surfaced, so be sure you have them handy.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Steve" <artigat1_at_hotmail.com> wrote in message
news:d2dd7454.0301140907.62ec0c4a_at_posting.google.com...

> The error is:
>
> ERROR at line 1:
> ORA-00600: internal error code, arguments: [kokbnp2], [904], [], [],
> [], [],
> [], []
Received on Tue Jan 14 2003 - 11:31:11 CST

Original text of this message

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