| DB Link [message #334068] |
Tue, 15 July 2008 06:45  |
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  |
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 |
pablolee
Messages: 2882
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 #334087 is a reply to message #334084] |
Tue, 15 July 2008 07:20 |
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 #334097 is a reply to message #334092] |
Tue, 15 July 2008 07:43 |
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 |
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 |
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
