Search code examples
oracleplsqloracle-sqldeveloperoracle-apex

How to access to wwv_flow_request_verifications

I want to create a custom captcha in oracle apex. I find a tutorial, in that tutorial he uses wwv_flow_request_verifications table, but when I want to use that table, apex shows me this error: this table or view does not exists. This is my code:

Declare
vCount NUMBER :=0;
BEGIN
SELECT 1 into vCount FROM vww_flow_request_verifications
WHERE session_id = :APP_SESSION 
END;

This is just an example How should I access to wwv_flow_request_verifications table?

Solution

  • Unless you are connected as the APEX schema, you will need to prefix the table with your APEX schema name which will vary based on the version of APEX you have installed.

    I have APEX 19.2 installed so my query would look like this:

    select * from apex_190200.wwv_flow_request_verifications;