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

Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql curser will not select from another schema ????

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

From: Gary England <gengland_at_hiwaay.net>
Date: 1997/09/17
Message-ID: <34209953.298E@hiwaay.net>#1/1

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

Original text of this message

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