| General Information |
| Note |
This package is undocumented and its purpose elusive. The point of this library entry is just to document what I have found. |
| Source |
{$ORACLE_HOME}/apex/core/wwv_flow_val.sql |
| 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_CUSTOM_AUTH_STD |
WWV_FLOW_VAL_LIB |
|
| Exceptions |
| Error Code |
Reason |
| ORA-32058 |
Invalid Caller |
| ORA-28000 |
Account Locked |
| ORA-28001 |
Password Expired |
|
| Security Model |
No privileges granted |
| |
| 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; |
