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......
Posted by at

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

October 27, 2007 at 3:47 PM
Jason said...

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

October 28, 2007 at 1:14 AM
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

October 28, 2007 at 3:04 AM
Jason said...

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

October 28, 2007 at 7:28 AM

Post a Comment

Subscribe to: Post Comments (Atom)