Oracle WWV_FLOW_VAL
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
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
WWV_FLOW_AUTHENTICATION_NATIVE WWV_FLOW_CUSTOM_AUTH_STD WWV_FLOW_VAL_LIB
Documented No
Exceptions
Error Code Reason
ORA-32058 Invalid Caller
ORA-28000 Account Locked
ORA-28001 Password Expired
First Available Not known
Security Model Owned by SYS with EXECUTE granted to APEX_040200
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 use it wwv_flow_val(username IN VARCHAR2, password IN VARCHAR2) RETURN BINARY_INTEGER;
SQL> conn / as sysdba
Connected.

SQL> SELECT wwv_flow_val.verify_user('C##ABC', 'C##ABC')
2 FROM dual;
SELECT wwv_flow_val.verify_user('C##ABC', 'C##ABC')
*
ERROR at line 1:
ORA-32058: operation restricted to SYSDBA users
ORA-06512: at "SYS.WWV_FLOW_VAL", line 32
ORA-32058: operation restricted to SYSDBA users

Related Topics
Packages

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved