{"id":184,"date":"2012-06-05T19:55:54","date_gmt":"2012-06-06T02:55:54","guid":{"rendered":"http:\/\/www.klsoftware.com\/blog\/?p=184"},"modified":"2021-06-01T10:27:22","modified_gmt":"2021-06-01T16:27:22","slug":"ucm-search-getfile-checkin-with-plsql","status":"publish","type":"post","link":"https:\/\/www.klsoftware.com\/blog\/?p=184","title":{"rendered":"UCM: Search, GetFile, Checkin with PL\/SQL"},"content":{"rendered":"<p>&#8220;Proof of concept&#8221; programming in many cases is the first draft of a finished product.  Several of my starter programs are in the download section of this blog.  They are PL\/SQL programs that demonstrate simple Checkin, GetFile, and Search functionality.  Besides using RIDC, when needing to retrieve content or Check-in content, these little programs can really help.<\/p>\n<p>These are just proof of concept programs, so you will need to add any additional logging.  Also, this program uses functionality originally found in flex_ws_api.  This can be found on Jason Straub&#8217;s <a href=\"https:\/\/jastraub.blogspot.com\/2009\/10\/rest-now-supported-in-flexwsapi-and.html\" title=\"FLEX_WS_API\" target=\"_blank\" rel=\"noopener\">blog<\/a>.  Flex_ws_api has also been incorporated into Oracle&#8217;s Application Express in the <a href=\"https:\/\/docs.oracle.com\/cd\/E23903_01\/doc\/doc.41\/e21676\/apex_web_service.htm\" title=\"APEX_WEB_SERVICE\" target=\"_blank\" rel=\"noopener\">APEX_WEB_SERVICE<\/a> API.  This code has also found its way into <a href=\"https:\/\/code.google.com\/p\/plsql-utils\/\" title=\"PL\/SQL Utils\" target=\"_blank\" rel=\"noopener\">Alexandria<\/a>, a PL\/SQL Utils library.<\/p>\n<p>With just a few additional lines of code, you can pull documents out of a database, and check them into UCM.  All with PL\/SQL code.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;Proof of concept&#8221; programming in many cases is the first draft of a finished product. Several of my starter programs are in the download section of this blog. They are PL\/SQL programs that demonstrate simple Checkin, GetFile, and Search functionality. Besides using RIDC, when needing to retrieve content or Check-in content, these little programs can [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,32,13],"tags":[],"class_list":["post-184","post","type-post","status-publish","format-standard","hentry","category-code","category-plsql","category-ucm"],"_links":{"self":[{"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/184","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=184"}],"version-history":[{"count":4,"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/184\/revisions"}],"predecessor-version":[{"id":386,"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/184\/revisions\/386"}],"wp:attachment":[{"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.klsoftware.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}