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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Urgent: SET ROLE in a stored procedure

Re: Urgent: SET ROLE in a stored procedure

From: Dmitri Blinov <Dmitri_Blinov_at_dialogbank.com>
Date: Wed, 28 Oct 1998 13:19:33 +0300
Message-ID: <3636EFB5.DEED454B@dialogbank.com> 





> Unfortunately, you can't. Oracle will tell you :


> ORA-06565: cannot execute SET ROLE from within stored procedure





And what about DBMS_SESSION.SET_ROLE procedure ?



PLSQL has syntax limitation and for that reason there are exist
several packages, which allows you to use the same functionality by
calling their functions. One of them is DBMS_SESSION.



Dmitry.
Received on Wed Oct 28 1998 - 04:19:33 CST












Original text of this message













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