{"id":1489,"date":"2025-06-13T13:41:57","date_gmt":"2025-06-13T11:41:57","guid":{"rendered":"https:\/\/oracle.malin.pl\/?p=1489"},"modified":"2025-06-13T13:44:50","modified_gmt":"2025-06-13T11:44:50","slug":"workflow-mailer-hasla","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1489","title":{"rendered":"Workflow mailer &#8211; has\u0142a"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT\np.parameter_id,\np.parameter_name,\nv.parameter_value value\nFROM\nfnd_svc_comp_param_vals_v v,\nfnd_svc_comp_params_b p,\nfnd_svc_components c\nWHERE\nc.component_type = 'WF_MAILER'\nAND v.component_id = c.component_id\nAND v.parameter_id = p.parameter_id\nAND p.parameter_name IN ( 'OUTBOUND_PASSWORD', 'INBOUND_PRIVATE_KEY_PASSWORD' )<\/pre>\n\n\n\n<p>Has\u0142a wprowadzone w definicji Workflow mailer &#8211; mo\u017cna odszyfrowa\u0107:<\/p>\n\n\n\n<pre id=\"artifactFileContent\" class=\"wp-block-preformatted\">ECX_OBFUSCATE.ECX_DATA_ENCRYPT  (  l_input_string  =&gt; :1, l_qual_code =&gt; 'D', l_output_string =&gt; :2, errmsg          =&gt; :3, retcode         =&gt; :4  )}<\/pre>\n\n\n\n<p>Je\u017celi by\u015bmy chcieli zaszyfkowa\u0107 has\u0142o i je wrzuci\u0107 do bazy danych to:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ENCRYPT_CALLABLE_STMT = \"{ CALL   ECX_OBFUSCATE.ECX_DATA_ENCRYPT  (  l_input_string  =&gt; :1, l_output_string =&gt; :2, errmsg          =&gt; :3, retcode         =&gt; :4  )}\";<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>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&#8217; AND v.component_id = c.component_id AND v.parameter_id = p.parameter_id AND p.parameter_name IN ( 'OUTBOUND_PASSWORD&#8217;, 'INBOUND_PRIVATE_KEY_PASSWORD&#8217; ) Has\u0142a wprowadzone w definicji Workflow mailer &#8211; mo\u017cna odszyfrowa\u0107: &hellip; <a href=\"https:\/\/oracle.malin.pl\/?p=1489\">Czytaj dalej <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[40,203],"tags":[115],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1489"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1489"}],"version-history":[{"count":2,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1489\/revisions"}],"predecessor-version":[{"id":1492,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1489\/revisions\/1492"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}