{"id":71,"date":"2016-05-10T17:31:35","date_gmt":"2016-05-10T09:31:35","guid":{"rendered":"http:\/\/www.tiptoperp.net\/?p=71"},"modified":"2016-05-10T17:33:00","modified_gmt":"2016-05-10T09:33:00","slug":"oracle-%e5%ae%a2%e6%88%b7%e7%ab%af%e5%ae%89%e8%a3%85%e4%b8%8e-plsql-%e8%b0%83%e7%94%a8%e9%93%be%e6%8e%a5-tiptop-erp%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/www.tiptoperp.net\/?p=71","title":{"rendered":"Oracle \u5ba2\u6237\u7aef\u5b89\u88c5\u4e0e PLSQL \u8c03\u7528\u94fe\u63a5 TIPTOP ERP\u6570\u636e\u5e93"},"content":{"rendered":"<p>\u5b89\u88c5\u524d\u9700\u786e\u8ba4\u64cd\u4f5c\u7cfb\u7edf\u7248\u672c\uff0c\u64cd\u4f5c\u7cfb\u7edf\u7248\u672c\u4e0d\u540c\uff0c\u6240\u9700\u4f7f\u7528\u7684\u5ba2\u6237\u7aef\u7248\u672c\u4e5f\u4f1a\u4e0d\u540c\uff0cWindows 7 \u53ca\u4ee5\u4e0a\u7248\u672c\u8bf7\u4f7f\u7528 Oracle 11g \u5ba2\u6237\u7aef\uff0cWindows 7 \u4ee5\u4e0b\u7248\u672c\u8bf7\u4f7f\u7528 Oracle10g \u5ba2\u6237\u7aef\uff0c\u5b89\u88c5\u65b9\u5f0f\u57fa\u672c\u76f8\u540c<\/p>\n<p>\u4e00\u3001Oracle \u5ba2\u6237\u7aef\u5b89\u88c5<br \/>\n1. \u89e3\u538b\u5ba2\u6237\u7aef\u7684\u5b89\u88c5\u7a0b\u5e8f\u5305<br \/>\n2. \u6253\u5f00\u89e3\u538b\u540e\u7684\u5b89\u88c5\u7a0b\u5e8f\u76ee\u5f55 client<br \/>\n3. \u70b9\u51fb setup \u7a0b\u5e8f\uff0c\u5f00\u59cb\u5b89\u88c5\u5ba2\u6237\u7aef<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-72\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/1.jpg\" alt=\"1\" width=\"566\" height=\"187\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/1.jpg 566w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/1-300x99.jpg 300w\" sizes=\"auto, (max-width: 566px) 100vw, 566px\" \/><\/p>\n<p><!--more--><br \/>\n4. \u5b89\u88c5\u6a21\u5757\uff0c\u9009\u62e9\u7ba1\u7406\u5458\uff0c\u4e0b\u4e00\u6b65<br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-73\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/2.jpg\" alt=\"2\" width=\"558\" height=\"414\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/2.jpg 558w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/2-300x222.jpg 300w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><\/a><\/p>\n<p>5. \u00a0\u9009\u62e9\u8df3\u8fc7\u66f4\u65b0\uff0c\u4e0b\u4e00\u6b65<br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-74\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/3.jpg\" alt=\"3\" width=\"558\" height=\"415\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/3.jpg 558w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/3-300x223.jpg 300w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><\/a><\/p>\n<p>6. \u5b89\u88c5\u8bed\u97f3\u6839\u636e\u9700\u6c42\u9009\u62e9\uff0c\u6216\u4f7f\u7528\u9ed8\u8ba4\uff0c\u4e0b\u4e00\u6b65<br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-75\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/4.jpg\" alt=\"4\" width=\"559\" height=\"414\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/4.jpg 559w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/4-300x222.jpg 300w\" sizes=\"auto, (max-width: 559px) 100vw, 559px\" \/><\/a><\/p>\n<p>7. \u9009\u62e9\u5ba2\u6237\u7aef\u5b89\u88c5\u76ee\u5f55\uff0c\u8bbe\u7f6e\u5b8c\u6bd5\u540e\uff0c\u4e0b\u4e00\u6b65<br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/5.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-76\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/5.jpg\" alt=\"5\" width=\"558\" height=\"413\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/5.jpg 558w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/5-300x222.jpg 300w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><\/a><br \/>\n8. \u5f00\u59cb\u8fdb\u884c\u7cfb\u7edf\u68c0\u67e5\uff0c\u5982\u679c\u51fa\u73b0\u7f3a\u5c11\u5148\u51b3\u6761\u4ef6\uff0c\u70b9\u51fb\u5168\u90e8\u5ffd\u7565\uff0c\u4e0b\u4e00\u6b65\u5f00\u59cb\u5b89\u88c5<br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/6.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-77\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/6.jpg\" alt=\"6\" width=\"556\" height=\"415\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/6.jpg 556w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/6-300x223.jpg 300w\" sizes=\"auto, (max-width: 556px) 100vw, 556px\" \/><\/a><\/p>\n<p>9. \u5f85\u5b89\u88c5\u5b8c\u6210\u540e\uff0c\u70b9\u51fb\u5173\u95ed\uff0c\u6253\u5f00\u5f00\u59cb\u83dc\u5355\u6839\u636e\u4ee5\u4e0b\u6307\u5411\u987a\u5e8f\u6253\u5f00\u76f8\u5173\u76ee\u5f55 \u5f00\u59cb&gt;\u6240\u6709\u7a0b\u5e8f&gt;Oracle &#8211; OraClient11g_home1&gt;\u914d\u7f6e\u548c\u79fb\u690d\u5de5\u5177&gt;Net Configuration Assistant<\/p>\n<p><a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/7.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-78\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/7.jpg\" alt=\"7\" width=\"550\" height=\"742\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/7.jpg 550w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/7-222x300.jpg 222w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/a><\/p>\n<p>10. \u6839\u636e\u56fe\u7247\u987a\u5e8f\u914d\u7f6e\u76d1\u542c\u4fe1\u606f\uff0c\u7528\u4e8e\u540e\u7eed\u5de5\u5177\u8c03\u7528\u6570\u636e\u5e93<br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/8.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-79\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/8.jpg\" alt=\"8\" width=\"547\" height=\"741\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/8.jpg 547w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/8-221x300.jpg 221w\" sizes=\"auto, (max-width: 547px) 100vw, 547px\" \/><\/a><br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/9.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-80\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/9.jpg\" alt=\"9\" width=\"550\" height=\"741\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/9.jpg 550w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/9-222x300.jpg 222w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/a><br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/10.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-81\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/10.jpg\" alt=\"10\" width=\"555\" height=\"737\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/10.jpg 555w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/10-225x300.jpg 225w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/a><br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/11.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-82\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/11.jpg\" alt=\"11\" width=\"547\" height=\"742\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/11.jpg 547w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/11-221x300.jpg 221w\" sizes=\"auto, (max-width: 547px) 100vw, 547px\" \/><\/a><br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/12.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-83\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/12.jpg\" alt=\"12\" width=\"557\" height=\"369\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/12.jpg 557w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/12-300x198.jpg 300w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><\/a><\/p>\n<p>\u4e8c\u3001 PLSQL \u914d\u7f6e<br \/>\n1. PLSQL \u5b89\u88c5\u6b65\u9aa4\u7565\uff0c\u53ef\u53c2\u8003\u7f51\u4e0a\u8d44\u6599<br \/>\n2. \u6253\u5f00 PLSQL \u8fd0\u884c\u7a0b\u5e8f\uff0c\u70b9\u51fb Cancel \u53d6\u6d88\u94fe\u63a5<br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/13.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-84\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/13.jpg\" alt=\"13\" width=\"464\" height=\"286\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/13.jpg 464w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/13-300x184.jpg 300w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/a><\/p>\n<p>3. \u5728\u9876\u90e8\u83dc\u5355\u680f\u4e2d\uff0c\u9009\u62e9\u5de5\u5177&gt;\u914d\u7f6e<br \/>\n4. \u8bbe\u7f6e\u76f8\u5173\u53c2\u6570\uff0c\u53ea\u60f3\u5230 Oracle \u7684\u5b89\u88c5\u76ee\u5f55<br \/>\n\u4f8b\uff1a<br \/>\nORACLE_HOME<br \/>\nC:\\oracle\\Administrator\\product\\11.2.0\\client_1 OCI LIBRARY<br \/>\nC:\\oracle\\Administrator\\product\\11.2.0\\client_1\\bin\\oci.dll<br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/14.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-85\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/14.jpg\" alt=\"14\" width=\"552\" height=\"264\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/14.jpg 552w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/14-300x143.jpg 300w\" sizes=\"auto, (max-width: 552px) 100vw, 552px\" \/><\/a><br \/>\n5. \u4fdd\u5b58\u8bbe\u7f6e\u540e\uff0c\u9000\u51fa PLSQL\uff0c\u518d\u6b21\u6253\u5f00\u65f6\u53ef\u901a\u8fc7\u4e0b\u62c9\u6761\u9009\u62e9\u4e4b\u524d<br \/>\nOracle \u5ba2\u6237\u7aef\u4e0a\u914d\u7f6e\u7684\u8fde\u7ebf\u4fe1\u606f\uff0c\u8f93\u5165\u8d26\u53f7\u5bc6\u7801\u540e\uff0c\u767b\u9646\u6570\u636e\u5e93<br \/>\n<a href=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/15.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-86\" src=\"http:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/15.jpg\" alt=\"15\" width=\"462\" height=\"281\" srcset=\"https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/15.jpg 462w, https:\/\/www.tiptoperp.net\/wp-content\/uploads\/2016\/05\/15-300x182.jpg 300w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/a><br \/>\n6. \u540e\u7eed\u76f8\u5173\u5f00\u53d1\u64cd\u4f5c\u53ef\u53c2\u8003\u7f51\u4e0a\u8d44\u6599<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"slide-text-bg2\"><span>\u5b89\u88c5\u524d\u9700\u786e\u8ba4\u64cd\u4f5c\u7cfb\u7edf\u7248\u672c\uff0c\u64cd\u4f5c\u7cfb\u7edf\u7248\u672c\u4e0d\u540c\uff0c\u6240\u9700\u4f7f\u7528\u7684\u5ba2\u6237\u7aef\u7248\u672c\u4e5f\u4f1a\u4e0d\u540c\uff0cWindows 7 \u53ca\u4ee5\u4e0a\u7248\u672c\u8bf7\u4f7f\u7528 <\/span><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[4,15,6],"class_list":["post-71","post","type-post","status-publish","format-standard","hentry","category-tiptop-","tag-oracle","tag-plsql","tag-tiptop"],"_links":{"self":[{"href":"https:\/\/www.tiptoperp.net\/index.php?rest_route=\/wp\/v2\/posts\/71","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tiptoperp.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tiptoperp.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tiptoperp.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tiptoperp.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=71"}],"version-history":[{"count":2,"href":"https:\/\/www.tiptoperp.net\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":88,"href":"https:\/\/www.tiptoperp.net\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions\/88"}],"wp:attachment":[{"href":"https:\/\/www.tiptoperp.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tiptoperp.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tiptoperp.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}