This discussion is archived
6 Replies Latest reply: Jun 14, 2010 4:05 AM by 562502 RSS

Get region ID within region condition PLSQL

562502 Newbie
Currently Being Moderated
Hi all,

I have a requirement to build a generic condition involving the region ID - in other words - I want to build a plsql function which is able to get the region ID from which it has been called

Perfect would be if I could do "V('REGION_ID')" – but it is not working.

Not working too is – “RETURN somefunction(‘#REGION_ID#’);” (PLSQL Function Body Returning a Boolean)

Is there maybe a package variable with this value ?

if anybody would have a hint for me - this would be great

Thanks a lot


  • Correct Answers - 10 points
  • Helpful Answers - 5 points