Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i PL/SQL Cursors and Joins
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...Received on Tue Jan 14 2003 - 11:31:11 CST
> The error is:
>
> ERROR at line 1:
> ORA-00600: internal error code, arguments: [kokbnp2], [904], [], [],
> [], [],
> [], []