| General Information |
| Purpose |
This package is undocumented and its purpose elusive. The point of this library entry is just to document what I have found. |
| AUTHID |
CURRENT_USER |
| Constants |
| Name |
Data Type |
Value |
| VALID_USER |
PLS_INTEGER |
0 |
| INVALID_USER |
PLS_INTEGER |
1 |
| NULL_INPUT |
PLS_INTEGER |
-1 |
|
| Dependencies |
| DBA_USERS |
WWV_FLOW_SECURITY |
WWV_FLOW_VAL_LIB |
| WWV_FLOW_CUSTOM_AUTH_STD |
WWV_FLOW_VAL |
|
|
| Exceptions |
| Error Code |
Reason |
| ORA-32058 |
Invalid Caller |
| ORA-28000 |
Account Locked |
| ORA-28001 |
Password Expired |
|
| Security Model |
Owned by SYS with EXECUTE granted to APEX_030200 |
| Source |
{$ORACLE_HOME}/apex/core/wwv_flow_val.sql |
| |
| VERIFY_USER |
| Appears non-functional based on the test shown. But that may just be due to not understanding how utilize it. |
wwv_flow_val(username IN VARCHAR2, password IN VARCHAR2) RETURN BINARY_INTEGER; |
SELECT wwv_flow_val.verify_user('UWCLASS', 'UWCLASS')
FROM dual;
SELECT wwv_flow_val.verify_user('UWCLASS', 'Id10T')
FROM dual;
SELECT wwv_flow_val.verify_user('Id10T', '43')
FROM dual; |
