Logout Problem 4.01
My app uses the proecudure: wwv_flow_custom_auth_std.logout_then_go_to_url this worked in 3.2 but has now stopped working in 4.0.1.00.03.
Here is info from my instance and apex.oracle.com neither is working but they give slightly different errors:
Authentication scheme:
Application express - Current
Logout url:
wwv_flow_custom_auth_std.logout_then_go_to_url?p_args=&APP_ID.:http://www.yahoo.com
url listed when hovering over:
http://myhost:7777/apex/ltest/wwv_flow_custom_auth_std.logout_then_go_to_url?p_args=122:http://www.yahoo.com
page says:
Not Found
The requested URL /apex/ltest/wwv_flow_custom_auth_std.logout_then_go_to_url was not found on this server.
http server error_log:
[Tue Aug 24 13:29:51 2010] [error] [client xxx.xxx.xx.xx] [ecid: 1282670991:xxx.xxx.xx.xxx:5551:0:1695,0] mod_plsql: /apex/ltest/wwv_flow_custom_auth_std.logout_then_go_to_url HTTP-404 ORA-20018: Unauthorized URL: http://www.yahoo.com\nORA-06512: at "APEX_040000.WWV_FLOW_SECURITY", line 3611\nORA-06512: at "APEX_040000.WWV_FLOW_CUSTOM_AUTH_STD", line 1609\nORA-06512: at "APEX_040000.WWV_FLOW_CUSTOM_AUTH_STD", line 2228\nORA-06512: at line 22\n
so I tried it on apex.oracle.com Uploaded my app and I get a similar message but not the same. not sure what the http server log says:
http://apex.oracle.com/pls/apex/f?p=24128
workspace: epic
app 24128
logout url:
http://apex.oracle.com/pls/apex/wwv_flow_custom_auth_std.logout_then_go_to_url?p_args=24128:http://www.yahoo.com
page says:
Not Found
Sorry!The page requested was not found.
On my instance as an apex app user:
desc wwv_flow_custom_auth_std
PROCEDURE
-------------------------------------------
AUTHENTICATION_STATUS
AUTHENTICATION_STATUS
FLOWCHART_LOGIN
FLOWCHART_PERPAGE
GET_COOKIE_PROPS
GET_COOKIE_PROPS
GET_COOKIE_PROPS
GET_COOKIE_PROPS
GET_COOKIE_PROPS
GET_LDAP_PROPS
GET_LDAP_PROPS
GET_LDAP_PROPS
GET_LDAP_PROPS
GET_LDAP_PROPS
GET_LDAP_PROPS
GET_LDAP_PROPS
GET_SESSION_ID_FROM_COOKIE (FUNCTION)
GET_USERNAME (FUNCTION)
IS_SESSION_VALID (FUNCTION)
LDAP_AUTHENTICATE (FUNCTION)
LDAP_AUTHENTICATE
LDAP_AUTHENTICATE
LDAP_AUTHENTICATE
LDAP_AUTHENTICATE
LDAP_AUTHENTICATE
LDAP_AUTHENTICATE
LDAP_AUTHENTICATE
LDAP_AUTHENTICATE
LDAP_AUTHENTICATE
LDAP_AUTHENTICATE
LDAP_DNPREP (FUNCTION)
LDAP_DNPREP
LOGIN
LOGIN
LOGIN
LOGIN
LOGIN
LOGIN
LOGIN
LOGIN_PAGE
LOGOUT
LOGOUT
LOGOUT
LOGOUT
LOGOUT_THEN_GO_TO_PAGE
LOGOUT_THEN_GO_TO_URL
PORTAL_SSO_SENTRY_V0 (FUNCTION)
PORTAL_SSO_SENTRY_V1 (FUNCTION)
POST_LOGIN
POST_LOGIN
POST_LOGIN
POST_LOGIN
POST_LOGIN
POST_LOGIN
REMOVE_SESSION
WS_LOGIN
WS_LOGIN
WS_LOGIN
WS_LOGIN
WS_LOGIN
WS_LOGIN
WS_LOGIN
WS_LOGIN
WS_LOGOUT
WS_LOGOUT
WS_LOGOUT
WS_POST_LOGIN
WS_POST_LOGIN
WS_POST_LOGIN
WS_POST_LOGIN
WS_POST_LOGIN
WS_POST_LOGIN
select object_name, object_type, status
FROM DBA_OBJECTS
where object_name = 'WWV_FLOW_CUSTOM_AUTH_STD';
object_name object_type status
WWV_FLOW_CUSTOM_AUTH_STD SYNONYM VALID
WWV_FLOW_CUSTOM_AUTH_STD PACKAGE VALID
WWV_FLOW_CUSTOM_AUTH_STD PACKAGE BODY VALID
WWV_FLOW_CUSTOM_AUTH_STD PACKAGE VALID
WWV_FLOW_CUSTOM_AUTH_STD PACKAGE BODY VALID
Any ideas?
Thanks in advance,
Justin