Re: Set Role From a Stored Procedure

From: Victor L. Artchakov <victor_at_rias.khv.ru>
Date: 1997/06/26
Message-ID: <ABdXeTtSrS@rias.khv.ru>#1/1

> Is anyone familiar with a way to issue a Set Role from within a stored
> procedure? Thanks.
>

Hello!
Use DBMS_SQL package.
example:
l
  1 CREATE OR REPLACE PROCEDURE set_role   2 IS
  3 cursor_handle INTEGER;
  4 BEGIN

  5       cursor_handle := DBMS_SQL.OPEN_CURSOR;
  6       DBMS_SQL.PARSE(cursor_handle,'SET ROLE ALL',DBMS_SQL.V7);

  7* END;
SQL> / Procedure created.

SQL> exec set_role

PL/SQL procedure successfully completed.

Best wishes
Victor L. Artchakov
Khabarovsk Russia
victor_at_rias.khv.ru Received on Thu Jun 26 1997 - 00:00:00 CDT