APEX

Hi,

I am invoking web service using APEX pl/sql code and passing username and password in code. I don't think this is good approach. Is there any other way I can avoid hard coding credentials in code. Another approach I can think of having db table with those details.

Here is sample,

l_result := apex_web_service.make_request(

            p_url => 'https://adc-fap0828-fa-ext.oracledemos.com:443/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL',

            p_action => 'http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/ErpIntegrationService/uploadFileToUcm',

            p_envelope => l_envelope,

            p_username => 'scm_impl',

            p_password => 'XXXXXX',

            p_wallet_path => 'file:/u02/oracle/DEMO1226/12.1.0/admin/DEMO1226/cloud_wallet',

            p_wallet_pwd  => 'WalletPasswd123'

            );

Thanks,

Santosh