How to pass value of variable in procedure to Javascript function in Apex

Question

I have variable in local procedure that rendering data to pop-up window I'm using oracle apex 20.2 Oracle Database 18 c

Variable name :l_factor_count

I want to pass this variable value to be used in Javascript function inside this procedure

After I did some research I found that this variable is local and needs to be related with page item but I don't know how do that because I use the procedure to do all the work and rendering data in pop-up as I said before.

Is the code in the two images part of the same procedure? Or is it part of the same package but different procedures? — Anuswadh
– Anuswadh, Commented Feb 25, 2021 at 10:35

Paulo Künzel · Accepted Answer · 2021-03-24 18:23:01Z

1

There are 2 ways of doing what you want

Divide you code in 2 parts.

1º Execute the PL/SQL required sending the values e returning them accordingly. Submitting this values in a dynamic action is APEX 101, so you should be fine here.

2º Execute a second action with the JavaScript code grabbing these values.

Execute an Ajax Call

Use apex.server.process to call you PL/SQL function and make it return your values to continue the process.

I do not advise you to my JavaScript and PL and if possible try to avoid it.

If you don't know how to do the steps from either item, then you might be doing stuff that, at the moment, is to advanced for you. So please check out some tutorials, anything online is going to help a lot.

answered Mar 24, 2021 at 18:23

Paulo Künzel

8592 gold badges8 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to pass value of variable in procedure to Javascript function in Apex

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related