SELECT p.parameter_id, p.parameter_name, v.parameter_value value FROM fnd_svc_comp_param_vals_v v, fnd_svc_comp_params_b p, fnd_svc_components c WHERE c.component_type = 'WF_MAILER' AND v.component_id = c.component_id AND v.parameter_id = p.parameter_id AND p.parameter_name IN ( 'OUTBOUND_PASSWORD', 'INBOUND_PRIVATE_KEY_PASSWORD' )
Hasła wprowadzone w definicji Workflow mailer – można odszyfrować:
ECX_OBFUSCATE.ECX_DATA_ENCRYPT ( l_input_string => :1, l_qual_code => 'D', l_output_string => :2, errmsg => :3, retcode => :4 )}
Jeżeli byśmy chcieli zaszyfkować hasło i je wrzucić do bazy danych to:
ENCRYPT_CALLABLE_STMT = "{ CALL ECX_OBFUSCATE.ECX_DATA_ENCRYPT ( l_input_string => :1, l_output_string => :2, errmsg => :3, retcode => :4 )}";