Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Atlanta, USA) who is an Oracle Certified Cloud Architect Professional, OCI Autonomous DB specialist as well as Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist with extensive expertise in Database design , PL/SQL, Oracle Apex, Microsoft SSIS, ETL, Power BI, Qlik Sense, OBIEE. Contact: qaiuminfo@gmail.com
Search This Blog
Tuesday, September 17, 2019
How to add Captcha In Your Login Page in Oracle Apex
Step 1
Create a item in your login page.
Step 2
Copy below code into item "Post Text"
<div style="background-color:#FFF; border:1px solid #ececec; padding:3px;">
<img width="25" height="25",=""
src="APEX_050100.wwv_flow_image_generator.get_image?p_position=1&p_sessionid=&APP_SESSION."><img
width="25" height="25",=""
src="APEX_050100.wwv_flow_image_generator.get_image?p_position=2&p_sessionid=&APP_SESSION."><img
width="25" height="25",=""
src="APEX_050100.wwv_flow_image_generator.get_image?p_position=3&p_sessionid=&APP_SESSION."><img
width="25" height="25",=""
src="APEX_050100.wwv_flow_image_generator.get_image?p_position=4&p_sessionid=&APP_SESSION."><img
width="25" height="25",=""
src="APEX_050100.wwv_flow_image_generator.get_image?p_position=5&p_sessionid=&APP_SESSION.">
</div>
Step 3
Create a process and copy the code into your process and select when process execute button.
DECLARE
vCount NUMBER := 0;
BEGIN
IF TRIM (:P101_CAPTCHA) IS NULL
THEN
RAISE_APPLICATION_ERROR (-20001,
'Please Confirm Verification Code.');
END IF;
BEGIN
SELECT 1
INTO vCount
FROM APEX_050100.wwv_flow_request_verifications
WHERE SESSION_ID = :APP_SESSION
AND SUBSTR (VERIFICATION_STRING, 1, 5) = :P101_CAPTCHA;
EXCEPTION
WHEN OTHERS
THEN
RAISE_APPLICATION_ERROR (-20001,
'Please Confirm Verification Code.');
END;
IF vCount = 1
THEN
NULL;
ELSE
RAISE_APPLICATION_ERROR (-20001,
'Please Confirm Verification Code.');
END IF;
END;
Step 4
Error Message
#SQLERRM_TEXT#
Subscribe to:
Post Comments (Atom)
PDF to Text Covert by Oracle Apex
Here are the steps to convert and get the character into a region by Oracle Apex. Step1. Create a page and Copy-Pest the below code into Pa...
-
Search by keyword from Oracle Database Objects. select owner, type, name, line, text from dba_source where 1 = 1 and text like '%TEXT Y...
-
We Can Export Application Components individually from Oracle Apex. Application > Shared Components > Export Application Compo...
THis is not work in apex.oracle.com can anyone one help me
ReplyDeleteOracle has deprecated "wwv_flow_image_generator"
DeleteObsolete in Apex 20.2
ReplyDelete