Saturday, October 27, 2007

APEX + PL/SQL + HTML + JAVASCRIPT = Mas Confusion (PART 1)

I don't know if I am the only one who has had this problem, but here it is:

How do you call a JAVASCRIPT through HTML using PLSQL in an APEX application? I have the answer......or another answer I should say......

HTP.P('')
did not work......

4 comments:

Patrick Wolf said...

Hi,

why not just create a HTML region to call Javascript? For example with the following code

<script type="text/javascript">
your_javascript_function();
</script>

Patrick

Jason said...

Yes, that would work, but how do you call PL/SQL from an HTML area? I could not figure that one out.

Patrick Wolf said...

You have to do that with AJAX calling an on-demand process of APEX. See Carl Backstrom's example application.

If this PL/SQL procedure doesn't need session variables from APEX you can also directly call it. See the download image example here.

Patrick

Jason said...

So that's how you do it from HTML...well, I will add that to the ol' bag of tricks. Thanks!