Tree link to run a procedure
I would like to run a PL/SQL procedure when a user clicks on a link on a hierarchical tree node (leaf). To test how this would work, I created the tree and PL/SQL annonymous block with conditional processing. When I click on the tree leaf link, the page refreshes, but nothing else happens. The PL/SQL block does not seem to be reacting to the Request (RunIT). Can I do this? and if so, what am I missing?
My tree query:
select "DISP_TYPE" id,
"PARENT_ID" pid,
"DISPLAY_NAME" name,
'f?p=&APP_ID.:5:&SESSION.:RunIT' link,
null a1,
null a2
from "#OWNER#"."GAZ_JOBS_TREE" t
PL/SQL Annonymous block:
select sysdate into :P5_currdatetime from dual;
Conditional Processing on block:
Request = Expression 1
Expression 1 = RunIT
Thanks, Todd