nested cursor select using database link gives ORA-00600

From: Al <munroae_at_yahoo.com>
Date: 12 Feb 2002 13:06:51 -0800
Message-ID: <788eb9ba.0202121306.535901bc@posting.google.com>

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:06:51 CST