Home » SQL & PL/SQL » SQL & PL/SQL » How to access package via DBlink without using Public synonym (Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production)
How to access package via DBlink without using Public synonym [message #344793] Mon, 01 September 2008 05:01 Go to next message
NewLife
Messages: 170
Registered: April 2008
Senior Member
Hi guys,

How do i access a package via DBlink without using Public synonym?

Re: How to access package via DBlink without using Public synonym [message #344803 is a reply to message #344793] Mon, 01 September 2008 05:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Private synonym?

Regards
Michel
Re: How to access package via DBlink without using Public synonym [message #344805 is a reply to message #344803] Mon, 01 September 2008 05:20 Go to previous messageGo to next message
NewLife
Messages: 170
Registered: April 2008
Senior Member
Well, that's a good answer, but i am sorry for not framing my question properly:

How do i access a package which is present in another database via a DB link without using synonyms?

is it possible ?

[Updated on: Mon, 01 September 2008 05:24]

Report message to a moderator

Re: How to access package via DBlink without using Public synonym [message #344818 is a reply to message #344805] Mon, 01 September 2008 05:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a db link that connect to a user that has direct access to the procedure, either because it is the owner or because there is a synonym in the remote db.

Regards
Michel
Re: How to access package via DBlink without using Public synonym [message #344831 is a reply to message #344818] Mon, 01 September 2008 06:09 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Just append the link name to the end of the all to the package/procedure:
 begin
   pkg_test.proc@mylink;
 end;
Re: How to access package via DBlink without using Public synonym [message #344835 is a reply to message #344831] Mon, 01 September 2008 06:16 Go to previous messageGo to next message
NewLife
Messages: 170
Registered: April 2008
Senior Member
hey cool, got it, thanks guys Smile
Re: How to access package via DBlink without using Public synonym [message #344844 is a reply to message #344831] Mon, 01 September 2008 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
JRowbottom,

This only works if remote user has access to the package without any need to supply schema name.

Regards
Michel
Re: How to access package via DBlink without using Public synonym [message #344878 is a reply to message #344844] Mon, 01 September 2008 09:05 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I think we had different ideas about what the OPs problem was.

I thought he was unsure about the syntax of calling a package over a Db likn directly - you thought he was unsure how to get access to the right schema at the far end of the link.

It's possible the Op will reply again and let us know who was most correct, but I'm not holding my breath.
Smile
Re: How to access package via DBlink without using Public synonym [message #344888 is a reply to message #344878] Mon, 01 September 2008 10:22 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes I agree we didn't see the question in the same way.
I think you're right (OP replied to your message not mine).
Anyway, both are interesting.

Regards
Michel
Previous Topic: cursoe creation
Next Topic: System Integration
Goto Forum:
  


Current Time: Wed Dec 07 07:08:19 CST 2016

Total time taken to generate the page: 0.15789 seconds