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

Dan Clamage wrote:
>
> Anders Hattestad <hattis_at_bigfoot.com> wrote in article
> <34200529.285E_at_bigfoot.com>...
> > 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.
>
> You have a permission problem. PL/SQL won't recognize permissions granted
> via a role. The permission must be granted directly to the user.

What!!! I have been using roles to grant permission to objects in PL/SQL ever since roles and PL/SQL were in the same release together!

ORACLE parses right to left. There has to be a syntax problem in the module. Cut it down the to minimum that fails and sent the whole thing.

>
> Either that or you've overlooked a typo. "TRAFTEKS.STED_DEFS" sure looks
> like transmission line noise to me. Or a TECO editor command (ha ha-- this
> is a paraphrase from the tongue-in-cheek article "Real Programmers Don't
> Use Pascal" written about 12 years ago. Did I just date myself or what?).
>
> - Dan Clamage dclamage_at_idcomm.com
  Received on Wed Sep 17 1997 - 00:00:00 CDT