Home » SQL & PL/SQL » SQL & PL/SQL » DB Link (Oracle 10G)
DB Link [message #334068] Tue, 15 July 2008 06:45 Go to next message
santosh.chalikwar
Messages: 6
Registered: July 2008
Junior Member
Hi All,
We are using DB Link to Replicate remote data in our local data base.But now we don't want to use DB Link ...So Please suggest me what changes we have to made in our packages and stored procedures.


Re: DB Link [message #334082 is a reply to message #334068] Tue, 15 July 2008 07:05 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Quote:
We are using DB Link to Replicate remote data in our local data base.But now we don't want to use DB Link

Why ? Any reasoning for that.

Regards

Raj
Re: DB Link [message #334083 is a reply to message #334068] Tue, 15 July 2008 07:07 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Quote:
So Please suggest me what changes we have to made in our packages and stored procedures.


None whatsoever. Since you have supplied no useful information, in order to be able to give you an answer, we must make up some assumptions. I'm going to assume that none of your procedures and packages use any dblinks, therefore you don't need to make any changes.
HTH(n)

[Updated on: Tue, 15 July 2008 07:08]

Report message to a moderator

Re: DB Link [message #334084 is a reply to message #334068] Tue, 15 July 2008 07:13 Go to previous messageGo to next message
jyothsna1612
Messages: 68
Registered: June 2008
Member
DB links are made to access the data from remote database.
Without using that i think it's not possible
Re: DB Link [message #334087 is a reply to message #334084] Tue, 15 July 2008 07:20 Go to previous messageGo to next message
santosh.chalikwar
Messages: 6
Registered: July 2008
Junior Member
Currently our packages uses db links ...
but we don't want to use it now...we have given user id and password ..through which we have to access that remote database..
so what changes will be their in package..
Re: DB Link [message #334090 is a reply to message #334087] Tue, 15 July 2008 07:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
so what changes will be their in package..

What for?

Regards
Michel
Re: DB Link [message #334092 is a reply to message #334090] Tue, 15 July 2008 07:34 Go to previous messageGo to next message
santosh.chalikwar
Messages: 6
Registered: July 2008
Junior Member
I will reframe my question as..
How to use User Id and password instead of DB link to access remote data base...
Re: DB Link [message #334097 is a reply to message #334092] Tue, 15 July 2008 07:43 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
From within a stored procedure - you can't.
Oracle do provide a way of seeing objects owned by a user on a remote database - it's called a Database link.

From a SQL script you can change your current connection by using the CONNECT command, but from within a procedure or function there is no way of doing it that I am aware of.
Re: DB Link [message #334102 is a reply to message #334092] Tue, 15 July 2008 07:49 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Quote:

I will reframe my question as..
How to use User Id and password instead of DB link to access remote data base...

I am going to ask you the same question again. Why ? What is the reasoning for that ? Why you don't want to use DB-Link ?

Regards

Raj
Re: DB Link [message #334103 is a reply to message #334097] Tue, 15 July 2008 07:50 Go to previous message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
i'm not sure if this makes any sense, but if you just want to remove the use of dblinks in stored procs, will this do?

create view vw_tab as
select col.. from tab@dblink


create procedure p as
begin
select col..from vw_tab...
end;
Previous Topic: Oracle 9i Before insert trigger is not working
Next Topic: How to access specification's or body's same name constants.
Goto Forum:
  


Current Time: Sat Dec 03 22:24:04 CST 2016

Total time taken to generate the page: 0.19704 seconds