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

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

Re: Urgent:Remote Database link and stored procedures

From: <harronc_at_ibm.net>
Date: Sat, 14 Aug 1999 10:13:05 +0700
Message-ID: <37b4df37@news1.us.ibm.net>


This is a bug in Oracle. Contact Oracle support.

Ramesh Subbyian wrote in message <37B345A9.7938FAAB_at_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
>
>
Received on Fri Aug 13 1999 - 22:13:05 CDT

Original text of this message

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