Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HTMLDB_UTIL.COUNT_CLICK questions

flaviocJul 18 2005 — edited Jul 22 2005
Hello team,
I guess you know that parameter p_workspace mentioned in the parameter list of HTMLDB_UTIL.COUNT_CLICK procedure description in the documentation is wrong.
The name of the parameter is p_company for some reason, but it still refers to the workspace id.

Parameter p_company, although apparently optional, is actually required to make the thing work, otherwise the click log will remain empty forever.

Another aspect that is not mentioned in the documentation is the way clicks are logged.
There is no counter at all, there are just click logs, grouped by the various columns. If the optional columns are null, then the log will contain very few lines as it doesn't distinguish betweeen different users.

My understanding is that if one really wants to count the external clicks, one must find a way to create a unique key value and pass it to the p_id parameter.

So, how would you implement this, supposing that you want to count external clicks also for non-authenticated users?
Is it possible at all?
Should I perhaps generate a unique "page view counter" using an oracle sequence and feed it as p_id parameter to function count_click?

Bye,
Flavio
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2005
Added on Jul 18 2005
1 comment
285 views