Re: PS/SQL Procedure

"Geoffrey" <g.dufour_at_swing.be> wrote in message news:<3c502b63$0$75157$ba620e4c_at_news.skynet.be>...
> Hi,
>
> Can you tell me why this script does not work ?
>
> (I have the right system privileges)
>
> =======================================================================
>
> CREATE OR REPLACE PROCEDURE test IS
>
> thesid NUMBER := 0;
>
> BEGIN
>
> Select sid into thesid from v$session where program = 'blablabla' and status
> != 'KILLED';
>
> END test;
>
> /
>
> quit;
>
> =======================================================================
>
> Regards.

You have privilege through a *role*. Roles are ignored during compilation of stored procedures.
As I and some others answer this question almost daily, and you don't mention a version, please search the comp.databases.oracle.server archives at http://groups.google.com for a full solution.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Jan 25 2002 - 10:12:01 CET