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!

Adding an executable button to a classic report

Z NDec 17 2024

Alrighty so I'm trying to create a button that inactivates an account on click.

The idea would be: if I click the button on the inactive/active button, it'll execute a plsql function in the background that'll active/inactivate the account.

Now - here's where it gets iffy:

  • How do I pass along the value of the Activity Date down to my PLSQL code?
BEGIN
pkg.activate('active', <ACTVITIY_DATE>);
END; 
  
  • How do I get the button to work so it activates the code on click?

Was going to be my plan and do a jQuery that executes code. Would this work?

This post has been answered by Scott Wesley on Dec 18 2024
Jump to Answer
Comments
Post Details
Added on Dec 17 2024
7 comments
1,000 views