Search This Blog

Tuesday, April 14, 2020

Redirect One Server App To Another Server App Without Second Time Login In Oracle Apex


1. Create Report With URL Generation                Source Server 

 SELECT   'http://URL/f?p=' 

          || '101'
          || ':'
          || 2
          || ':'
          || :APP_SESSION
          || '::::P2_USER,P2_SESSION_ID,P2_LOG_ID,P2_BRANCH_CODE:'
          || 'admin' -- :app_user (this user must be common between server)
          || ','
          || :APP_SESSION
          || ','
          || :AI_LOG_ID  -- This one is just for passing value
          || ','
          || :AI_BRANCH_CODE CARD_LINK,  --This one is just for passing value
          '48' CARD_TITLE,
          'Go Another Server App' CARD_TEXT
     FROM DUAL
 
2. Create A Public page with like below items               Destination Server           
     
P2_USER,P2_SESSION_ID,P2_LOG_ID,P2_BRANCH_CODE:'

3. Create a Process on load before header for authentication


begin
apex_authentication.login (p_username   =>:P2_USER,
                           p_password   => '123');
                                    
Exception
    when others then raise_application_error(-20001, sqlerrm);
End;

4. Create a Dynamic Action On Load with Submit event


5. Create a branch and select the page where you want to redirect.


6. Create Custom Authentication with boolean return function like below


function my_authentication (

    p_username in varchar2,
    p_password in varchar2 )
    return boolean
is
    
begin
    Return true;
exception
    when NO_DATA_FOUND then return false;
end;

Don't Forget to Copy past the function to Authentication Function Name

No comments:

Post a Comment

Split A String By Coma (,)

Step 1.  create or replace type split_tbl as table of varchar2(32767); Step 2. create or replace function split (     p_list varchar2,...