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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

APEX.PROCESSING
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
315 views