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!

Recaptcha Problem

MungoHenningMay 28 2011 — edited May 29 2011
Hi Folks,
The google recaptcha plug-in looks interesting, hence I thought I would add in on to a Registration page
that I am building for a small experimental application.

(read more about the plugin via page http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-plug-ins-182042.html )

The details there might be adequate for experienced developers, but I'm having "picnic" problems with this
plugin ("picnic" == "Problem In Chair, Not In Computer" :-)

Okays, so I download the plugin and integrate it into the application (Apex v4.? before I get crucified).
I also gets the Public and Private keys from Google too, and set these parameters into Apex.

So, time to actually use this plugin on the page: I create an item of this recaptcha type and run the page. Voila, the
item appears. I can type words into the rectangle box that appears, and everything looks fine and dandy.

Hmmm... how do I go about detecting whether what the end user types squares with the squidgy words shown in
the box? Answer: some sort of Validation.
But how to tickle the plugin to ask it how it is doing?

I guess I need to call some PL/SQL function available from the plugin, but it's not clear what to actually call.
I did venture in to the plugin's PL/SQL code and had a look at:

function validate_recaptcha (
p_item in apex_plugin.t_page_item,
p_plugin in apex_plugin.t_plugin,
p_value in varchar2 )
return apex_plugin.t_page_item_validation_result

but I didn't find any hints as to what these four parameters are. Never mind the parameter names, some of those
parameter types doesn't make for "obvious" reading.

So the question is, having a lovely recaptcha on the screen makes the page look nice, but what additional
steps does a person need to take in order to interrogate the widget as to whether its input is valid?

Thanks in advance

Mungo

P.S. Patrick Wolf's page at http://www.inside-oracle-apex.com/adding-captcha-to-your-oracle-apex-application/ has
helped me initially but I wonder if the "future" bit at the top (dated November 2011 :-) is meant to be an "or"
when compared to the subsequent paragraphs. As in "look at the Google version OR follow these instructions".
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2011
Added on May 28 2011
3 comments
601 views