{"id":101,"date":"2005-11-18T02:31:26","date_gmt":"2005-11-17T17:31:26","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=101"},"modified":"2017-01-31T19:50:55","modified_gmt":"2017-01-31T10:50:55","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-oci-%ed%81%b4%eb%9e%98%ec%8a%a4","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=101","title":{"rendered":"\uc624\ub77c\ud074 OCI \ud074\ub798\uc2a4"},"content":{"rendered":"<p>2004\ub144\uc5d0 \ub9cc\ub4e4\uc5b4 \uc37c\ub358 OCI \ud074\ub798\uc2a4\uc785\ub2c8\ub2e4. OCI\ub294 Oracle Call Interface\uc758 \uc57d\uc790(\ubc29\uae08\uc804\uae4c\uc9c0 C\uac00 Common\uc778\uc9c0, C\uc5b8\uc5b4\uc758 C\uc778\uc9c0 \ud574\uae54\ub838\ub2e4\ub294 \u3161\u3161;)\uc774\uad6c\uc694.<\/p>\n<p>\ubcc4\ub3c4\uc758 ODBC, OLEDB \ub4f1\uacfc \uac19\uc740 MS\uc758 \ub370\uc774\ud130\uc5f0\uacb0\uc744 \uc704\ud55c \uc124\uc815 \uc5c6\uc774 \uc624\ub77c\ud074 \uc11c\ubc84\uc5d0 \uc5f0\uacb0\ud558\uc5ec \ucffc\ub9ac\ub97c \ub0a0\ub9b4 \uc218 \uc788\uad6c\uc694. OCI\ub97c \uc774\uc6a9\ud55c \ub370\uc774\ud130 \ucc98\ub9ac\ub294 <strong>\uc18d\ub3c4\uba74\uc5d0\uc11c \uadf8 \uc5b4\ub5a4 \ubc29\ubc95\ubcf4\ub2e4 \ube60\ub985\ub2c8\ub2e4<\/strong>.<\/p>\n<p>\uc624\ub77c\ud074 \uc608\uc81c \uc18c\uc2a4\ub97c \ubcf4\uace0 \ud074\ub798\uc2a4\ud654\ud55c \uac83\uc774\uad6c\uc694. \uba54\ubaa8\ub9ac\ub9ad\uc740 \uc544\uc9c1 \ubc1c\uacac\ud558\uc9c0 \ubabb\ud588\uad6c\uc694. \uc544\ub798\ub294 \uc608\uc81c \ucf54\ub4dc\uc785\ub2c8\ub2e4.<\/p>\n<pre>\r\n#include \"OCIw.h\"\r\n\r\nint main() {\r\n    COCIw OCI;\r\n    OCI.OpenDB(\"oragis\", \"scott\", \"tiger\");\r\n\r\n    OCI.ExecuteDML(\"INSERT INTO TEST2 (NAME, AGE) VALUES ('\uae40\ud615\uc900', 29)\");\r\n    OCI.ExecuteDML(\"INSERT INTO TEST2 (NAME, AGE) VALUES ('\ud64d\uae38\ub3d9', 27)\");\r\n\r\n    OCI.Query(\"SELECT * FROM TEST2\");\r\n    OCI.DisplayRecords();\r\n\r\n    OCI.CloseDB();\r\n\r\n    return 0;\r\n}\r\n<\/pre>\n<p>OCIw.h \ud30c\uc77c\uc5d0 \uc120\uc5b8\ub41c COCIw \ud074\ub798\uc2a4\uac00 \uc8fc\uc778\uacf5\uc785\ub2c8\ub2e4. \uc790\uc720\ub86d\uac8c \uc0ac\uc6a9\ud558\uc2dc\uae38&#8230;.. \ubc84\uadf8\ub098 \uac1c\uc120\uc810\uc740 \ub313\uae00\ub85c&#8230;&#8230;<\/p>\n<p style='text-align:center'><a href=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/381075.zip\"><img width='64' src='\/images\/download.svg' \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>2004\ub144\uc5d0 \ub9cc\ub4e4\uc5b4 \uc37c\ub358 OCI \ud074\ub798\uc2a4\uc785\ub2c8\ub2e4. OCI\ub294 Oracle Call Interface\uc758 \uc57d\uc790(\ubc29\uae08\uc804\uae4c\uc9c0 C\uac00 Common\uc778\uc9c0, C\uc5b8\uc5b4\uc758 C\uc778\uc9c0 \ud574\uae54\ub838\ub2e4\ub294 \u3161\u3161;)\uc774\uad6c\uc694. \ubcc4\ub3c4\uc758 ODBC, OLEDB \ub4f1\uacfc \uac19\uc740 MS\uc758 \ub370\uc774\ud130\uc5f0\uacb0\uc744 \uc704\ud55c \uc124\uc815 \uc5c6\uc774 \uc624\ub77c\ud074 \uc11c\ubc84\uc5d0 \uc5f0\uacb0\ud558\uc5ec \ucffc\ub9ac\ub97c \ub0a0\ub9b4 \uc218 \uc788\uad6c\uc694. OCI\ub97c \uc774\uc6a9\ud55c \ub370\uc774\ud130 \ucc98\ub9ac\ub294 \uc18d\ub3c4\uba74\uc5d0\uc11c \uadf8 \uc5b4\ub5a4 \ubc29\ubc95\ubcf4\ub2e4 \ube60\ub985\ub2c8\ub2e4. \uc624\ub77c\ud074 \uc608\uc81c \uc18c\uc2a4\ub97c \ubcf4\uace0 \ud074\ub798\uc2a4\ud654\ud55c \uac83\uc774\uad6c\uc694. \uba54\ubaa8\ub9ac\ub9ad\uc740 \uc544\uc9c1 \ubc1c\uacac\ud558\uc9c0 \ubabb\ud588\uad6c\uc694. \uc544\ub798\ub294 \uc608\uc81c \ucf54\ub4dc\uc785\ub2c8\ub2e4. &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=101\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;\uc624\ub77c\ud074 OCI \ud074\ub798\uc2a4&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[117,8],"tags":[],"class_list":["post-101","post","type-post","status-publish","format-standard","hentry","category-cpp","category-programming"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=101"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/101\/revisions"}],"predecessor-version":[{"id":3755,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/101\/revisions\/3755"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=101"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}