Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set an Application Item from PL/SQL

329650Apr 7 2009 — edited Apr 9 2009
I am attempting to set an Application Item

After login to my app, I want to retrieve a row from my SETTINGS table and populate some Application Items with the settings information so that I can
display some of that settings information on every page.

Just to start, I created one Application Item named F106_YEAR

I then created a Shared Components Application Process which executes on New Session: After Authentication
I created this process as an Anynomous PL/SQL block.

declare
aucyr varchar(4);

begin
select year into auctyr
from settings;
:F106_YEAR := aucyr;
end;


I've tried a couple of other Syntax tricks attempting to reference the Application Item F106_YEAR from within PL/SQL (like V('F106_YEAR') but nothing seems to be working.
I'm sure that I am missing something simple. Can someone tell me how to set an Application Item from PL/SQL?


Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2009
Added on Apr 7 2009
15 comments
8,568 views