Oracle database Link & stored procedures

I am trying to access a remote database using oracle 8.0.4 I have 2 databases running on servers server1 and server2. I created a database link to server1 from server2 by using command,

Create database link Oracle.world_at_server1 connect to dc identified by dc using 'server1';

dc is a user name with password dc. I am able to see tables in server1 using SQLPLUS. For example,

select count(*) from test_at_oracle.world_at_server1

provides the number of rows in the test table on server1 server.

If I use this table in a stored procedure I get internal error.

create or replace procedure sp_test
as
begin
declare row_count number;
begin
select count(*) into row_count from
test_at_oracle.world_at_fujitsu;
end;
end;

ORA-00600: internal error code, arguments: [17069], [168877280], [], [], [], [], [], []

I appreciate your help.
Thanks
Ramesh

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 12 1999 - 16:55:51 CDT