DBMS_SESSION.SET_ROLE

From: Andrea Cannaos <Andrea.Cannaos_at_deagostini.it>
Date: Fri, 17 Jul 1998 09:46:59 +0200
Message-ID: <35AF0172.9B78BD43_at_deagostini.it>



We need to set programmatically a non-default role into a form to have access to some objects referenced; in WHEN-NEW-FORM-INSTANCE we make a call to BMS_SESSION.SET_ROLE('ALL') and form hang up giving us end-of-file
communication channel; we try to do this with USER owner of all objects referenced but it's the same .. when we do this from SQLPLUS everything seems to work well ! please help us ...
--
           \\\\////
           &( oo )&
========oOO==(__)==OOo========

| |
|Andrea.Cannaos_at_deagostini.it|
| |
============================== || || (__) (__)
Received on Fri Jul 17 1998 - 09:46:59 CEST

Original text of this message