58.14 COUNT_CLICK Procedure
This procedure counts clicks from an application built in App Builder to an external site. You can also use the shorthand version, procedure Z
, in place of APEX_UTIL.COUNT_CLICK
.
Syntax
APEX_UTIL.COUNT_CLICK (
p_url IN VARCHAR2,
p_cat IN VARCHAR2,
p_id IN VARCHAR2 DEFAULT NULL,
p_user IN VARCHAR2 DEFAULT NULL,
p_workspace IN VARCHAR2 DEFAULT NULL,
p_referrer_policy IN VARCHAR2 DEFAULT NULL );
Parameters
Table 58-12 COUNT_CLICK Parameters
Parameter | Description |
---|---|
p_url |
The URL to which to redirect. |
p_cat |
A category to classify the click. |
p_id |
(Optional) Secondary ID to associate with the click. |
p_user |
(Optional) The application user ID. |
p_workspace |
(Optional) The workspace associated with the application. |
p_referrer_policy |
The referrer-policy HTTP response header. |
Example
The following example demonstrates how to use the COUNT_CLICK procedure to log how many users click on the http://example.com
link specified. Once this information is logged, you can view it by using the APEX_WORKSPACE_CLICKS view and in the reports on this view available to workspace and site administrators.
DECLARE
l_url VARCHAR2(255);
l_cat VARCHAR2(30);
l_workspace_id VARCHAR2(30);
BEGIN
l_url := 'http://yahoo.com';
l_cat := 'yahoo';
l_workspace_id := TO_CHAR(APEX_UTIL.FIND_SECURITY_GROUP_ID('MY_WORKSPACE'));
HTP.P('<a href=APEX_UTIL.COUNT_CLICK?p_url=' || l_url || '&p_cat=' || l_cat || '&p_workspace=' || l_workspace_id || '>Click</a>');
END;
See Also:
- FIND_SECURITY_GROUP_ID Function
- Deleting Click Counting Log Entries in Oracle APEX Administration Guide
- Managing Authorized URLs in Oracle APEX Administration Guide
Parent topic: APEX_UTIL