APEX

Hi,

I am implementing SSO (via OAM) to application in Apex 4.2.2 running on Apex Listener 2.0 in Weblogic 10g.

I am using http header variable:

HTTP Header Variable Name: HTTP_OAM_REMOTE_USER

URL: #CALLBACK#

Verify Username: After Login

Now, after successful authentication from OAM, I am redirected to page:

https://sso.company.com/apex/apex_authentication.callback?p_session_id=961981826025&p_app_id=100&p_ajax_identifier=4A2D490BD1A867A207B868A600A49323346E6E8940D16D7F38F2C436F786546F

Which has my application theme 26 and a error message: Null Username passed to login procedure

I know I have to set the user via apex_custom_auth package however where do I insert my code to set users, cookies and redirect user to first page?

Should it go in the textarea in "Source" or in Post-Authentication Procedure Name. I create adummy procedure like and tried putting it in Post Authentication Procedure Name but nothing was getting logged in my dummy test table.

    procedure sso_sentry
    IS
        n_hostname varchar2(4000):=null;
    BEGIN
        n_hostname:= OWA_UTIL.get_cgi_env('HOSTNAME');
        delete from test_table;
        COMMIT;
        INSERT INTO test_table(item,VALUE) VALUES('test', 'test');
        commit;
    end sso_sentry;

Any help appreciated. Thanks.