How to reference an application item inside a PL/SQL block
Barry DApr 28 2010 — edited Apr 28 2010APEX 3.2.0
I have created an application item named G_USER_PRIV and populate a value via login. I would like to reference G_USER_PRIV in a PL/SQL block.
Example:
begin
if G_USER_PRIV = 'widget' then
some code here;
elsif G_USER_PRIV = 'foo' then
other code here;
end if;
end;
I have tried using &G_USER_PRIV. and G_USER_PRIV and v('G_USER_PRIV') and am not having any luck. The APEX page erros out upon save with various errors depending on the solution.
Thanks in advance.
Barry D.