473,327 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Grant Problem?

I created a package using pl/sql.
In this package i have a dblink to another Database, call it DB2.
Meanwhile, Server2 has a DBlink to another Database, call it DB3.

Within my package, i have a sql that link to these DB2's view.
In the View of this DB2, it call a function from DB3 and take the data
from the DB3.

I run this package in few locations.
This package run fine except for one location.
so, i'm confident with my coding.

For this location,
When i declared the function that call the sql in public, it runs!!!
But when i declared it within the body, it DOESN"T run!!
(Ofcause, i want to declare it within the body and not public.)

May i know what caused this to be happenned?
Is it the grant problem?
(i don't have the priviledge to view the grant for each side.)

The error are as below when it connect from the DB2 to DB3:

5:26:08 PM Error: ORA-04052: error occurred when looking up remote
object ZE*****************@DBUXP4.RBG.INFINEON.COM
5:26:08 PM ORA-00604: error occurred at recursive SQL level 1
5:26:08 PM ORA-02019: connection description for remote database not
found
please help

regards,
felicia
Jul 19 '05 #1
1 6486
ko********@yahoo.com (kong) wrote in message news:<cc**************************@posting.google. com>...
I created a package using pl/sql.
In this package i have a dblink to another Database, call it DB2.
Meanwhile, Server2 has a DBlink to another Database, call it DB3.

Within my package, i have a sql that link to these DB2's view.
In the View of this DB2, it call a function from DB3 and take the data
from the DB3.

I run this package in few locations.
This package run fine except for one location.
so, i'm confident with my coding.

For this location,
When i declared the function that call the sql in public, it runs!!!
But when i declared it within the body, it DOESN"T run!!
(Ofcause, i want to declare it within the body and not public.)

May i know what caused this to be happenned?
Is it the grant problem?
(i don't have the priviledge to view the grant for each side.)

The error are as below when it connect from the DB2 to DB3:

5:26:08 PM Error: ORA-04052: error occurred when looking up remote
object ZE*****************@DBUXP4.RBG.INFINEON.COM
5:26:08 PM ORA-00604: error occurred at recursive SQL level 1
5:26:08 PM ORA-02019: connection description for remote database not
found
please help

regards,
felicia


Felicia, the ORA-02019 would seem to indicate that on one of your
instances the package owner does not have access the referenced db.
The link might be defined with an invalid TNS Service name or the
service name might be missing from the tnsnames.ora. Also the problem
could be because of public vs private db link definitions or public vs
private object synonym definitions one of which is either wrong or
interfering with finding the right object at the right database.

HTH -- Mark D Powell --
Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Bruce A. Julseth | last post by:
I am doing something wrong or have something set up wrong. When I issue mysql> grant all on * to mike identified by 'joented' with grant option; Query OK, 0 rows affected (0.69 sec) It...
14
by: Martin v. Löwis | last post by:
The Python Software Foundation is seeking grant proposals for projects related to the further development of Python, Python-related technology, and educational resources. The PSF plans to issue...
4
by: Amardeep Verma | last post by:
Hi, I have a quick question. Which role/privileges are required before a user can give the statement "GRANT ALL PRIVILEGES"? Thanking you in Advance Have a nice day
0
by: Charles Cantrell | last post by:
I have recently set up mySQL on a Mandrake release of Linux (Version 7 of Mandrake, I believe), using the binary 4.0.13 standard release. The set up and start up all were normal, as far as I...
0
by: Charles Cantrell | last post by:
I have recently set up mySQL on a Mandrake release of Linux (Version 7 of Mandrake, I believe), using the binary 4.0.13 standard release. The set up and start up all were normal, as far as I...
0
by: Xerxes | last post by:
I am having a problem with accessing MySQL database from my PHP code. I tested accessing MySQL db locally and once things worked I created the same DB on my web hosting's server. No problem...
6
by: Xerxes | last post by:
When I use the following GRANT statement GRANT SELECT , INSERT , UPDATE , DELETE ON sassisc.* TO sassisc@localhost IDENTIFIED BY 'dodge3' it came back with an error message: SQL-query : ...
1
by: Shashidarcs | last post by:
Hi All, I have a problem here.. Say i have a stored procedure in the new query sheet and i would like to add grant permissions in textual content just below the procedure.. I jus want to...
7
by: MNNovice | last post by:
Please forgive me for this is a long request. I am designing a DB to capture expenses related to Federal Grants and to generate appropriate reports. Each grant starts with a Notice of Grant Award...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.