> I tried the DBMS_UTILITY.GET_PARAMETER_VALUE and it worked perfectly.
> I think I can not access V_$PARAMETER for some security reason implemented
> in our development environment.
That's great, but just so that the question will not reappear any time soon
with different database object, take heed to those who said that you had to
grant SELECT *directly* to the *user* owning your procedure - stored
procedures do NOT inherit privileges from roles, NO roles are active when
stored procedure is compiled or executed (unless it's authid current_user
in 8i+.)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Mon Sep 23 2002 - 12:06:33 CDT
