SET ROLE and stored procedures

	Hi!
	Is it possible to use SET ROLE command in a stored 
	procedure.

	I have a following procedure, which gives an error message
	from the SET ROLE command.

	create or replace procedure s_role is
	   vrole a.priv.user_role%TYPE;
   	begin
	   select user_role into vrole 
	   from a.priv where orauser=user;
	   set role vrole;
	end;

	Our attention is to check user role from a application
	priviledge table a.priv and then enable that role.
	But this is not working!   
	We have lost our PL/SQL User Guide for Oracle7 so I can't
	check this out.

	-Mikko Kuismin
	

-- 
Mikko Kuismin: NTC/TRS/TP-Production/Haukipudas
     internet: mikko.kuismin_at_ntc.nokia.com
          fax: +358-81-471766