APEX

Hi,

I´m new in Oracle Apex and i'm trying now to track outgoing links on my Apex 3.2.1 application.

When the user clicks on a link of my application that redirects to an outgoing site, I want them to be taken to the site (href) and I also want a background script that register in a oracle table this "click".

For example, i have this link in an APEX page:

When user cliks in this link, i would like to execute in background an oracle procedure, with a parameter. Let´s call this procedure, for example:

SP_REGISTRA_ACESS_LINK(:P19_COD_TOPICO).

This procedure insert a record in a table called BAC_ACESS, storing in it the SYSDATE and the value of ":P19_COD_TOPICO".

Is it possible to link to a new site and call an AJAX request at the same time?

Could some one give me a example of how i can do it? How i can implement it in my Apex 3.2.1 application?

I´m working with Apex 3.2.1 and RDBMS 9i. I can not upgrade none of these releases, cause Apex is installed in a production database that can be upgrade now to 10g/11g.

Best regards,

Sergio Coutinho