{"id":786,"date":"2012-05-30T16:14:41","date_gmt":"2012-05-30T14:14:41","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=786"},"modified":"2012-05-30T16:14:41","modified_gmt":"2012-05-30T14:14:41","slug":"przekazanie-parametru-do-procedury-z-atrybutu-typu-document-w-workflow","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=786","title":{"rendered":"Przekazanie parametru do procedury z atrybutu typu document w Workflow"},"content":{"rendered":"<p>W Workflow Builder s\u0105 r\u00f3\u017cne typy atrybut\u00f3w. Jednym z typ\u00f3w jest <em>Document<\/em>.<\/p>\n<p>Warto\u015b\u0107 takiego atrybutu jest pobierana z powi\u0105zanej procedury, do kt\u00f3rej mo\u017cna przekaza\u0107 parametry.<!--more--><\/p>\n<p><a href=\"http:\/\/oracle.malin.pl\/wp-content\/uploads\/2012\/05\/Attribute-document-type.png\"><img loading=\"lazy\" class=\"aligncenter size-medium wp-image-787\" title=\"Attribute - document type\" src=\"http:\/\/oracle.malin.pl\/wp-content\/uploads\/2012\/05\/Attribute-document-type-300x294.png\" alt=\"\" width=\"300\" height=\"294\" srcset=\"https:\/\/oracle.malin.pl\/wp-content\/uploads\/2012\/05\/Attribute-document-type-300x294.png 300w, https:\/\/oracle.malin.pl\/wp-content\/uploads\/2012\/05\/Attribute-document-type-306x300.png 306w, https:\/\/oracle.malin.pl\/wp-content\/uploads\/2012\/05\/Attribute-document-type.png 603w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Procedura musi przyjmowa\u0107 nast\u0119puj\u0105ce parametry:<\/p>\n<pre>procedure_name\u00a0\r\n(document_id in varchar2,\r\ndisplay_type in varchar2,\r\ndocument in out nocopy varchar2,\r\ndocument_type in out nocopy varchar2)<\/pre>\n<p>Procedura mo\u017ce zwraca\u0107 nast\u0119puj\u0105ce typy danych:<\/p>\n<p>&gt;&gt;\u00a0 PL\/SQL document (32 KB)<br \/>\n&gt;&gt;\u00a0 PL\/SQL CLOB Document (4GB)<br \/>\n&gt;&gt;\u00a0 PL\/SQL BLOB Document 4GB)<\/p>\n<p>Parametry przekazuje si\u0119 w postaci:<\/p>\n<pre>&lt;typ danych (bez znaku \/ &gt;:&lt;procedura&gt;\/&lt;parametr - sta\u0142a lub np. inny atrybut&gt;<\/pre>\n<p>np.<\/p>\n<pre>PLSQLCLOB:XX_AR_CMGT_WF_ENGINE.GET_AGING_DATA\/&amp;APPLICATION_NUMBER<\/pre>\n<p>Uwaga, przekazuj\u0105c parametr, b\u0119d\u0105cy innym atrybutem w procesie Workflow, trzeba\u00a0zwr\u00f3ci\u0107\u00a0uwag\u0119 na <strong>typ danych<\/strong> ! Musi to by\u0107 <strong>Varchar. <\/strong>Je\u015bli przekrzemy <strong>Number<\/strong>, do procedury zostanie przekazany<strong> Null.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>W Workflow Builder s\u0105 r\u00f3\u017cne typy atrybut\u00f3w. Jednym z typ\u00f3w jest Document. Warto\u015b\u0107 takiego atrybutu jest pobierana z powi\u0105zanej procedury, do kt\u00f3rej mo\u017cna przekaza\u0107 parametry.<\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[88,114],"tags":[140,138,139],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/786"}],"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\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=786"}],"version-history":[{"count":2,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/786\/revisions"}],"predecessor-version":[{"id":789,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/786\/revisions\/789"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}