Re: Query System-Views within Stored Procedures
From: Andrey Efimov <efa_at_leaves.spb.su>
Date: 1996/09/13
Message-ID: <01bba180$5bb9a700$9a2b7dc1_at_efa.leaves.spb.su>#1/1
Date: 1996/09/13
Message-ID: <01bba180$5bb9a700$9a2b7dc1_at_efa.leaves.spb.su>#1/1
Thomas Kuchenbuch <Thomas_Kuchenbuch_at_sz.maus.de> wrote in article
<199609112302.a16340_at_sz.maus.de>...
> Hi,
>
> We tried querying the View "v_$session" from a cursor inside a stored
> procedure. Same query works fine, if issued directly from SQL*DBA or
> SQL*Plus. Issued inside a stored procedure (or a package containing that
> procedure) the result constantly is "ORA-00942: Table or View does not
> exist".
>
> Any Hints?
>
> Regards, Thomas
>
> ---
> Send Mails >16kB to: TKuchenb_at_aol.com
>
To used the table in stored procedure user must take "REFERENCE" privilege
to this object.
If your privileges granted by Oracle roles, they cannot grant "REFERENCE"
privilege.
Received on Fri Sep 13 1996 - 00:00:00 CEST