Re: pl/sql curser will not select from another schema ????

What you have is a permission problem. In PL/SQL the only recognized privileges are those granted directly to a user, not those granted through a role.

Anders Hattestad wrote:
>
> Hi!
>
> I have a litle problem.
> I'm making a litle sql/pl code. I'm logged on as system with dba privl.
> when the I trie to compaile my code I get a error saying:
> PLS-00201: identifier 'TRAFTEKS.STED_DEFS' must be declared
> CURSOR c1 IS
> select dato from TRAFTEKS.STED_DEFS;
>
> It works from sql*plus.
>
> I have looked at Deja News and one person sayd it my be a premision
> problem. Thats not the case here.
>
> Have anyone a tip?
>
> Anders
Received on Wed Sep 17 1997 - 00:00:00 CDT