Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Urgent:Remote Database link and stored procedures
Hi,
I am trying to access a remote database using oracle 8.0.4. I have 2
databases running on servers db1 and
db2. I created a database link to db2 from db1 by using command,
Create database link Oracle.world_at_db2 connect to dc identified by dc using 'db2';
dc is a user name with password dc. I am able to see tables in db2. For example,
select count(*) from test_at_oracle.world_at_db2
This provides the number of rows in the test table on db2 server.
If I use this table in a stored procedure on db1 like,
create or replace procedure sp_test
as
begin
declare row_count number;
begin
select count(*) into row_count from test_at_oracle.world_at_db2;
end;
end;
I get internal error.
ORA-00600: internal error code, arguments: [17069], [168877280], [], [],
[], [], [], []
I appreciate your help.
Thanks
Ramesh
--
Ramesh Subbyian Work : 650-413-1217 http://www.inventa.com Pager : 888-709-3153Received on Thu Aug 12 1999 - 17:10:02 CDT
![]() |
![]() |