HTMLDB_UTIL.COUNT_CLICK questions
flaviocJul 18 2005 — edited Jul 22 2005Hello 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