RE: 7.3.4-8.1.7-9.2 Gateway Procedure problem
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 Aug 2004 14:28:14 -0400
Ron,
Sounds like a security problem. Make sure you have granted select, insert,
update & delete access directly to the dblink user in the 9.2 database. My
gues is that you are using roles.
Good Luck!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Smith, Ron L. [mailto:rlsmith@xxxxxxx]
Sent: Wednesday, August 11, 2004 2:21 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: 7.3.4-8.1.7-9.2 Gateway Procedure problem
I am using an 8.1.7 database between 7.3.4 and 9.2 to get by compatibility
problems doing inserts. I am using synonyms and dblinks.
If I do an sql select or insert in the 7.3.4 database that ends up going to
the 9.2 database it works fine. But when I try to compile a package with the
same synonym and dblink I get an error that says it can't find the
table@link in the 9.2 database.
The standalone select or insert works fine, but the compile fails. =20
Any ideas what I am missing?
Thanks!
Ron=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
