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!

Tree link to run a procedure

to437766kySep 4 2008 — edited Sep 5 2008
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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 3 2008
Added on Sep 4 2008
1 comment
316 views