Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Urgent:Remote Database link and stored procedures

Urgent:Remote Database link and stored procedures

From: Ramesh Subbyian <ramesh.subbyian_at_inventa.com>
Date: Thu, 12 Aug 1999 15:10:02 -0700
Message-ID: <37B3463A.30A5AFC1@inventa.com>

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-3153


Received on Thu Aug 12 1999 - 17:10:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US