Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Grant Problem?

Grant Problem?

From: kong <kongkong99_at_yahoo.com>
Date: 25 May 2004 02:38:29 -0700
Message-ID: <cc50806d.0405250138.6fd2da0f@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 ZEQ_READ.ZEQ_MASTER_at_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 Received on Tue May 25 2004 - 04:38:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US