Re: nested cursor select using database link gives ORA-00600

ORA-0600 = Call Oracle.

I'll bet on some corruption in the data dictionary ... but only Oracle can say.

Daniel Morgan

Al wrote:

> ORA-00600: internal error code, arguments: [kokbnp2], [942], [], [],
> [], [], [], []
>
> This message is returned when I attempt to do a query
> using cursors and database links i.e:
>
> select a.id, a.f_name, a.l_name,
> cursor (select b.child_name
> from child_at_alt_db b
> where b.parent_id = a.id) as child_name
> from parent_at_alt_db a
> order by a.l_name asc
>
> but when I do the same query using tables with data in my own schema
> it works fine.
>
> I am using an oracle 8.1.7 v2 database with a link to an oracle 7.3.4
> database
>
> I have also tried it with an oracle 8.1.7v3 database with a database
> link pointing to an oracle 8.1.7 v2 database and that fails also,
> while all the time working when querying in the 8.1.7 v2 database with
> local data.
>
> any help would be much appreciated.
>
> Thanks.
Received on Tue Feb 12 2002 - 15:13:51 CST