CODEWITHSUNDEEP
javascriptstored-proceduresoracle-apex
BODYBOND
BODYBOND

Reputation: 127

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

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 as shown in image here

I want to pass this variable value to be used in Javascript function inside this procedure If I put static value it's works fine but if I use the procedure variable it won't work!

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.

Upvotes: 0

Views: 1286

Answers (1)

Paulo Künzel
Paulo Künzel

Reputation: 849

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.

Upvotes: 1

Related Questions