存储过程的详细建立方法
1.先建存储过程
左边的浏览窗口选择 procedures ,会列出所有的存储过程,右击文件夹procedures单击菜单“new",弹出 template wizard窗口.
name框中输入 GetSumAndSub ,
parameters中填入: p1 in number , p2 in number ,m out number , b out number 。
单击ok,右边出现建立存储过程的代码窗口。其中内容为创建存储过程的语句。
在begin end 之间输入具体内容,最后如下;
create or replace procedure GetSumAndSub(p1 in number , p2 in number ,m out number , b out number) is
begin
m := p1+p2 ;
b := p1-p2 ;
end GetSumAndSub;
功能:求和与差
原形:GetSumAndSub(p1 in number , p2 in number ,m out
number , b out number)
参数:m=p1+p2 b=p1-p2
单击“保存”按钮,可将创建存储过程的sql语句保存在文件中,作备分之用^_^。
接着要做的就是 执行此sql语句来创建存储过程。方法为:
找到工具栏上的“齿轮”图标,鼠标放上面会显示 ‘EXECUTE(F8)',单击之。存储过程此时已经建立完毕。可为什么我在右边的procedures文件夹下看不到此存储过程?刷新一下ok~
2. 测试、调试存储过程
在左边的浏览窗口选中 Procedure_HP_HWLP_Select_Test 该存储过程,右击选菜单“TEST‘,右边会出现新的测试窗口。
说明:在测试窗口的下面你可以看到有一个参数列表,作输入参数值和查看out型参数值用。
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKIAAADWCAIAAADdI86bAAARLklEQVR4nO2d368dVRXH5w/xDbEUBAmJTzwYEnySSIjGB8FEAonpA0YTJEEDOYC0/GhFfoWKEQYjVkFakRv6w8KttPZif9DT9tKU0sqvEFLg6iY5jybHh2mn++611nevvWfmnPmxv2lu5uxZe+01+7PWnh9nOGTGmDzPTYs1nU7nHULnlZmEeQDqP+aMU12xaUZvyDgsDCNgtoeUZkoKC+8NlYSZjYpSpGGAwPARRajsCIK0bfQOgyJE1QyGx5HVO4+aasYjKqu5zE4MI0jSRHmrCEysPqEv7DKKRZvGyoL3BhoXZXXMGmPn0Oy/mlFYh/ZhSq70mcRaKiMMwAyCBgFVj3I21ayJJAiz08XeEGHMHrMdjbShnLKKUc64mvU2GklHWjZiSaNL+RpTzU4CshFQG3BI3oNvCDOePn0kcZjtksAxeF052/Vj1uzyZq7XsiHMGuPaMbP1AMrDmwfRE2iCMLP12mbMYAbpPNaO2elizxs7Fd6xZoeZBtpmzKGiFVZ9CLZ8NW7BHDr1hqf93C4DMTtovdUs5SwbpfKAZ7No413RaaSpZs1iUzHCGs7NNK3oxypRspjB7GgSHJPWTLdGTiTO/MwyQoSZHU85j2BXaJTpq4vq8mOeuxLm6sqMMdPWa96z1HnVcIGa1H5lxYo973JNalB5nmfT6dSk81+vlef5uUU7Ye6xEuZBKGEehBrBrHooo3h2L+0KeriWZDSYR6OR/bhqNBp5nTqP99inXRl5LEqftdG/4JGZ5slaxGPFfghhLgGPRqNplk2zzG4BTllgRqhgsFf/VNW7l/qUgtRI/5iWdmGjinarVJ7n55xSzDZg+18BGziV8NCJlhDizJAGVe71DoolhaTpjjGD2Coqz/Ps1R1fMgRzwfIc2unU2ZAKGheKNNcsddquMZOqoSHMod3nifnsZzcbgjkrS5nKV9ChmJ2/uIumgLyYvakAxJqx+WdvgDDYxNVEopdYzZm9UK9mXBa05FSJmQKm7J0poE40AUi9Gq1mZSbNrpoz7tzcHGYAj60GyYYOBNrngjk0MBBbRTW4aGMqDnJn+ZIWANoiiQ3J2a6OGeRc6zCz1Rx3CVaGCDhJ214S1CxINLHoXr0rKZmcUWgXtiO10QejkVjNxi7o8BsqZ4N+xHnAVqeUDdQVmMeg9t4I3TdHPx4pRHOZfmQLAnvz5ofXj6aweqY8z7PRiMdcKOJhZ1LbhKo5qTdKX0QOQqqvLmYeVVLNQpjLM3Ei3XWJmMu7Ju/tU1L7xWOe8dU1SCN2l74xqRCD2WY8Go2CkNO7UnqTSu9ZATbnL7hW0NwQg77goHogF7PDuNyIeDxifNMHMLNcld6wgZNt+u6dVp7nF/6rC2PNRUE04mEnLmXHku1ihAyogtkZyxDMXg+dFrNoZ9ZaHfHVhQQGlCy1YVOEZkx0SpkBYraruVQW+0Wkd+o1tUs3DEwLGoPUMlzM69atM/W9ViBhYMlJu5zydRpZ/1IMkmdqljCHYfZWM+1iCD/KI2GOFsIcvWiz27QRWOoXbZxSksOE+Zwqvj3ibNC9Xn7UA8tGr6CFASQKaGmtRMzGLujAt0cMd4Ej7ZLo0ur05gdOr4j23ghhjng84qyZgFZpQD1InqUN7142Qml576UQ5kLp7ZEeyI85qQdKmAehMMzLy8sL57W8vNx8eEn1SIV5PB4bYwq0thYWFmYWaFIV+THbjJ1diXRXxGMen1dBsahdY8zCatm7IgYGH5PqFYN5PB5PJpOVlZWVlZWCZVnKReN4PC7+Gq6gc1mOmZ1YzkcaZVB7kiMe88rKymQyKWAbgrkkbYR1ezqdFtgK2dv2wOVH9ptQ27L0STOmu6TZGmBLopax+EW7wDmZTMxqzAsLC8ViXi7a7OnZoegAtg/GZkwPz2Zszv+wKHVYw0zMQ2UBFBvOMdY7EFPNxbo9mUzKldnGrDk3A8xlS/lXs7Y7TvQLfpvl0MWTVnEgF3NRxOXi7JyebYErbT1ms/rHf8E5W1rNOo25EE3lxjEXjO1qXlpaKh+J0PtmmzQtTekMJFWzgZXKrmadxkyL2GFf10Au5oJoUc3mfB0vLS0Z7ikYe/0FLsHoGkUt6UTQoL02nZC9npWN0lRUHIi5BFtYWCgvvsrTcEHdFng24l20jZDLEuZ89dV1n87NTou0q+JA/H2zIYzLc/bYknSZbTsEFam57ihzgl3Y6TrfFTknMtrYOGZDGE8mk2IlL07YXsy42nLrVso5N7PHllt3GoWc9srzMB85hwMaK0pctEvGxQJeXnXT553Uo4GXUUHnZrsXvVgzXWY8S4mXYCVCWsTeryvo1NOEtTecCxDg1pHmCJMMqGbbyFvBSS0XjzmpZ0qYB6GEeRBKmAehhHkQisFMb2GT5qUGMdP716R5qUHMSZ1TwjwIJcyDUMI8CCXMg5AH80D+K+/ey485ke6B/Jhv2nNTEGm9cUqgmUmFOZo0+JUPjQ01VrYnOdJiDiWNFZE03nSZpSJ+oUayd34op6EfvgnAXBdp74/9sMag44xJS7+EFHo4bEvQ5OgVhtlL2k7GjJNzPNjGtB5zaBidwaypaS8G7/LFNmrWvRlIitOOzcl1ti+b3K1YtAvGxa9tA6d4KSuPH/QCrtqJmbYrM5ItiTlj1jC2owS8ozFrXDUqPWZN39Yt2krGxkpJcN7tB+agPGYb24VZzxiEGIHZkKQpt3GvRiWdQZ0IneNl011yC8wipH0KFsrYG6IeM9g1F8ZdlOqZdlwd6xdtnOOSN008SYX8mPWMk1or//fNiXEPlF4rGIQYzPO9iE1qQqpqTry7rrRoD0IBmPU1Xfs9MTiPpJsrjZqqZukWmTZqMsBrrCQ92Mcs9WNmn4rQmrPJ4YceygcjXlTZ6oeIjrcg0hFPaSR7px7Y2KpLi1kz0aWld9voqjnIOCIqKSRlMGBbH2SVadEr7NysSTFafGxHfDxSqeFSViaBXTSSDVD0csLa0Bi8xxKhsEU79EikGsJiu+AA5o6Z5mU5BJgQetTzxJxlI/pPNvbzU0rvKhSzIQBwd40Z9SbFiXtJfatIi/n7W/9n/wOYV3f0ny+lZLc/0g1pFA2DmWHW9G07ZvYrDVB/TugahI1ipsYRmDU5ihu9mV2LasZMOqomXUpeb7krWxxv5XCa/JBcSWsyHcXpAipViq265oPZNvBSifBfV3tvNLdqBoCNUO5ONURngKaweqb4K+30ukGHpL1vHnGaVZBJVZW+iByEEuZByI+5oTu5pFlKxKy8DE7qhBpZtPWPLKRd9IaHvYka7H1wqNCbnVj621YJZNBe6V4Zd6/Y3hu19O0RZ69ZjdlLxZs6IJ7QYwztgkNt6KFNI5i920ZRzfYB0w1g780qb0i1HKC3b3VvermY9YcKJlSSY+ZssKM4204LoC611Is5tHtbMOslzbI3bpAHjkOMmbplO+rNqmB2gi+38RE5Rz0fzN6XRvABA35eOXMkzZqRM4l1KNmDw5Fi87azh4xb5oY57qURy4P/ahxwwn/pEG3DrOnbUsze3xDCoocBAOAW2gs0NoQ51FtPMBMP/sRnl3S6RGuqWfLmWIIRlZJGKRvZtGbTXem5ouaD2TaQkIDSlz5Gx1P7tLZNc6tmfc6y9WpITVPhoRuqm3Yq+Eo7vU3QRal+eyS9NNJ1pdcKBqFKmAdyYuuBqmJOpDuhSMzS3WFSO1XpP3wFd73eFu8u++ZYeacEIh+4mjo3sw83WAOvE5pbQduagHufIgE/SqH0yD6poFUoFavGIRuVMrE0roKOMbQLGxV1W2/mtfTtEcmh0j+YTXuFAJ6V8YQmihezFFtFteJdMOCEdRg6Fh1FGlR5gEHt2EbTUl2NLNp4G7ChFA2X3RGQmsbsBO/kKNsXH3W98v6e9kj/qyNllMoK88oBTHlTY+wKG9dbzZpFRdlSXX7MVV4g0Uw9SGRazV7juI+aaL1mcUO0FzP49gKUsrQ00Q3Hxtux+kfQiM30aSc1dhIz6e5PfLCks6t0HGanIx0xaHKlmMtGNq3ZdFd6rqj5YLYNcCpoZsS7cnjjaaKAWqW5VbM3qamxphr0QzdUN+1UzJV2erOgc4p5eyRh7pzS2yODUFXMAzm3dV01YE6k2y///zwQbyTMnVD91aynHp0fQffEVQbqjRo5N9sVL92hYht8r0yXFrCtjAcfEWjvhOZzpa2cMmpWnimoDcs+aDgjJESEn7ZpDpgBD9aMdmGLVdqFa9cbWPQpqVWq+dxsz6lm4ZVsQLsR5hoA0MRjdPk3UMxGsUiyBt5eTiPFzGKjCAFOPBa26ZY0v9k5Cv0FElq1dG8oZtDXO5xDOmFm5H2BBAADk+tNDrY6QzE79sCJFDYIskOKxGx/ewHqVVpIQS/cGFHNRsAM/ARlZyfUIGbOVVXMXj8AFd2FC1p/Um+/6scsLYnErRYzWAnqOl9o9naXsakds+b8CixBi7PLQB7esdiOIHJs335FXmnjRTupbVLdN+MXSBLm9it93zwIoV/HT/x6I+X/VS7x7rbSK3+DUABmZU3rSz96kaAPMfAtED0NDW19avZ/UKScemqDyXlp0Xb7Vhsz1vvskLr99oi3moEBzTzbP06vzing1wrA7ATJW4t0r9NF6SFoCDyi0mFrFXZu9jK2bXD1YBvQbnSYnbFAJFIX1n//MZvYxZadLOUMsnXsRcimlH4sI+d0nzGH/gKJZoojpl7qq8yqVM1+zP/9wY/tf0rMgDeeQQlMHGbNLhyt0kNrFY8Z/wKJCfkiUmqhjQ5srLILNmDHYjNVCrL9ahAzbo/DzDbqP3rrlU0g3KUTqh8zu65KZrjFrJ5x1tLrR6pRTS5q2juhmjE7cwrWSdYStDi7qBPWs34XHQIs751T/JV2+mmKDkl735x+gaTTSl9EDkIJ8yCUMA9CCfMgxGPe/v5d20799MUztx49u9XpcPzzbdij/nlCD25UuiIG86tnfvHg0uW/H9+06eBVm5e/8e5/9pTW73y++5lT1773xV7gUYnZeVLRmzvUdorBvGHpkueP3myM2ffB5scOX7379MbjZ//21zO3Hfn4pS3Hb938/uU7ztx98KMti5/fffCTnHrUYI7DSbMBf0wqxWD+7aHvbn37DmPMjtP3P37gml0nN+08vf6p9y5/+PDaR5cve+jQ2g37L9k0vuyZs1duWb7FcWdPtPf5VxAP6qG6z+GIwfz6qSd/uW/N+sUrH9l3zdNvX/uP05s/+eLEI0e/tvHQFb85eP0L4588e+R7jx37+oY3vrrjxEbqUTn7bCqAWpQ8eAdKMtIl2Nbjtz+1/4adJx7+92eH3/106S/Hbl+/f+0Tb3y7NHh+fOv9+9Y8e+DmIx+97HjUzD6L00tIWhXAQEmFPDdUb3247e6dFz+wdMkDe6/4+zu/LtsX3r5v01uXPnRw7RNvfvPYhzvtLs6iXTbaBsZXnUDAp97J0OS/bz7wwQvP/etH97y25pHd3yobnzt4y3171mzee+PhD1bdX+lPw9GYDVnw8UBJRvl4ZP+ZP97z+trRrksfXbz+uX23Pb7nhg17rrr3tUv//ObPqbEz4/raxYTAeoCXjSSjxPz03hvvXfzKnS9/+a7tF9/5ykV3vnLRXdsv3nho7eOLN1BjgBkz8GJmL9odxpqruQFKhfn1k5t/988fvnnqxV9t/869i2v+dOBne07k247fsfvkY9QYlG8VzECJqFdhz7TfOPmH9TuuPvHxomSgvykCRZlUu4K/uth/akvDISXVr/QN1SCUMA9CCfMgdAFzntRrZeuSBqBs3bp11113XZZl0+l019FPdx278G/n0U8f3Pjk9LxefOmVOa7tec58vQ00nU5Ho9E0aTqdTqf/B3j972oMjaufAAAAAElFTkSuQmCC" alt="" /> aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAABBEAAAILCAIAAAAxBJP7AAAgAElEQVR4nO3d+bcV9Z03+voL7k+s+9P95eFZgTxXeO4KdLP6Dj2soCYxxmh4WoMjDrHbDCBJHKIIJ+mbJjgTQnAIEdsJRTO2T4xGBIPxqAmjMgkig6IxJogmvVbSd+37wz6ndu0avrv2wB7Ofr3WZ2GdOlXf+tZ31zl+36f2EK1Zs+aKK674+c9/fufj25RSSimllFIqVVE1Mxw+fPiu/7ldKaWUUkoppVI1lhn+4z/+4+6f7VBKKaWUUkqpVI1lhkqlsvqJl5VSSimllFIqVbXM8P2fv6yUUkoppZRSqaplhnue3KmUUkoppZRSqaplhnuf2lWy1tz3y+9/46HvXfP9u69afddXvnfnwrvuuu7e79+zoXwLSimllFJKdbmWP7LpiyN3XrDgW52tL47cufyRTV07xJoHf3HB335q9qTJna0L/vZTax78RdHQNZcZ7lv7/AOf//bDn17y+AXffuKi7zx18aqn5t3x1KV3PH7+7f/20atWnbnknjUbe341KKWUUkopla3PXX37z3+59cBbxztbP//l1s9dfXvXDvHpKX/95F13f7Dj152tJ++6+9NT/rpo6GqZ4d9+sbth/eiK5c8tXLt72S8PrPj1zv93w/brn9r6lZ9tvvKnryx5+tVlm0a/uvZ7H/1ymXaUUkoppZTqcl105bIDbx3/5ctHO1sH3jp+0ZXLunaI2ZMmv7/txbcf/l5n6/1tL86eNLlo6GqZ4f71exrWgydfveW6tW+v3f3ug4ffvvu1oyv3HrntlQPLNh9Y/tK+5Zs2/vP37vn7L9ftsvSc6PS771//5PknRTWn31397i1f+MhHl+65f+k5H/rCk+lj3Xfdh04656MnRR9dmu3Gk+efFOXssn7PVadHRXK3769aek500nW39LwbSqnO1JPnn/SR8+8r+nLP/evv/mj111P1B3/8N2H8eyz72++WL3xkAH6VKaVUH9e8hTe+dvT4xh1HO1uvHT0+b+GNXTvE7EmTj28ePfrgnW89dOdbD9351oNjVV1ztLowvvxWXd01tteDd9V2HF84vnl09qTJRUNXywwPPLO3YX33v1zwxD8s2v2NH/52w+5DP9ly5PEdrz7y/K+/89PR6x+79SPzfnTyslUzFqT3+tY50enXX3DSRy64f+8Dz+x94P7rP3T69x741jkf+sJTt37hIx/91t4Hntl79enRh77wVN1e1c2eeWpsx2+dU5gGqv9zHW+nupDtQ7r9PqxvnROddP2tHWvwqQtOSo9PamX6cPdf/6Ha98Yfr1p976O11Pe9nNaic64uXBm3UN/s/dd/aKwPRR0LtFZ3pnWP+/3XfyivM/nXRvHuV58en+neB57Ze+sXPpIcsfEvM7uXOmjdeOY/OolTCLSfGeG6x+jqbIpOnFG1CrYpOkq62w0OUXdRZX7MQ1dd8FotuBqTA1X+4csd8/SPQPrHM7lj7mUZ/xIr+LJ6Fiddf+vYv7VfU1ef/pEL7t8b/3pM1q1f+MgA/CpTSqk+rovHJvRvdrZeO3r84oU3ljnEv95+75yzLy+qf7393jKHmD1p8rGXNr35bytrdd/KN+8bW1513aK4wVXXLcpdk603/m3lsZc2zZ40uWjoapnhoQ37GtZ3/8sFv7p05cHlT7/70z17bnjquUvvfeDvr13xv196/9/c8O0pF/3PM25ZNWNB3o5PX3jSjAsfWD07+uw1Dyyacvrqh5Z9dsoXn77tizNmLxvf4PRFFxbdJRjf/qEN+2774ozo9NXVZuPluJ1rTo/GG6yv8d37upZ9Njpp0W0da7A65vse2rDvoQcWTYmqy09feFJtiK45PYoH86Fln42i8e3HdkkM5rLPRvVfTvni06nWEsct2nH17OQhqkcZO+WijuUeInjEsc5/9prCQSi9e90j8vSFJ0XJIbrm9KhgEMocdPXs2rA8feFJcW8bjWdgTPIfo/hw1UMEKrVN7lFyu114iNu+OCOqX3nN6VHdmtBVF75WS1yNLT5844c+vf7nMdla6qdjw+rZ2Z/cZZ9N/AqbceED1dGoWzO+4+rZJyV++5206MLTx7afvSy1V44B+M2mlFL9VBd/+ab9R48/s+NoZ2v/0eMXf/mmMoeYc/bl/1lsztmXlznE7EmT/zC68cj3bz+y+vYjq28/PL5QrTlnX14ZN+fsy797zddSaw6vvv1wYvsj37+92tQfRjfOnjS5aOhqmWHtxv2BuvdnW5av+cnCOZdcM+8Lv/m3n29/9FcHv/viS1c/uu5/fPOuf1j46Jk33/uJq35w5jdWzViQ3OvaT0VTvrR+7cb1F02bcdGDq0+O5l774A1TPrV67Y1zp3xp/fIvzTj5xqIjrj552g3LE2uWf2lGFEXRtBuWb1x/0bSouuPYyk+tjg+X3+CNc6d8aX34BHtfN86N6k+5vaqOefaBSAzRjXPHh271yVFm6G6cG0Vzry367tghsuszKx+8YUqtnVqXxr41dspFHcs9RPkj5g5C6d0fvGFKrcOrT47mnly7wOKWsz0scdDaiTc/nvmbFT1Gtc5f2+CCSW2Td5T8bhccIr6eb5wbRVE0PnrLvzSj3FXXzLVa+Di28PDFK9dfNC3x2NV+PMtck8nfOeO//RJDd+2nqkdffXJ14j8+UNVdqt/N+fX44A1Toihq/FAqpZQqrEu+cvP+o8fX7zja2dp39P1LvnJzmUM0zAxFO+4/ejw+xOxJk9/d9PShO246eOdNB++86eAdN48v3HTwzptWXnXNnLMv///GpZZXXnXNoTtvOnjnTdV/D95508E7b64uv7vp6dmTJhcNXS0zPPzL/UW1au0TN9xww7U3fGN0dHTNmjVfuvSfzzrrrMfueWjn99dvWHLvS9/+8cYF93/n//qnH3x06aoZC+r3XX/RtOjkm9ZfNG3GRWtXnxzN/draG6acsfrhm+ZOmb9++fwZJ9+0/qJpURRFJ9+UOujqk6fdsHz8y6+dEf5bWxSdsbq6Waad/Q//cn/1cIETzFS12+P/R691L7F+rHu1baJo7teS/Y//EDh26Oya1O7jba69YUrcVG05dOi8s6uOeW0Ap8xfP95I7VzGdrxpbpQY7UTfZly0tui7++tbC6yM14w3GH9r7Q1Txlou6Fj+IRodsW7QsoPQ1O7j37ppbnTG6uXzZ1SvtPxtQiOfHdsyQxcez7orvOAxig+XvDjLbJPbmdxu5x9i7IexNlDxoz++Zfiqa+5abTRQTTx8iZVrb5gSJVqIfzxDQ117RBLX8IyTz5iRPMrXzhgfimk3LI9/143vUv3u8vkzMqcz96L5M6bMv+Hk6lkopZRqvi75ys37j76/fsdbna1qZogPse/o8Wd2vJVbcWZIPSspcZ8hf8fkIaqZ4cDKpQe+s/TAyqWvr1x6YGVt4fXvLP3OV6+ac/blf6435+zLv/PVq8Y2+05trwPje1UzQ9HQ1TLDuk0Hcmv1Dzd+97vf3b1799q1a7du3fr888+vXr36lVdeOfPMM5/4+n0Pf2Lxtz98yf2zFn37Qxc+/smbVs1YkNfIhnnTZsxbe88p0dzr1i6ecsY9626eO2X+hhXzZ5xy84F1mw5UF1bMr92FnzJ/8SnTFq9INHLdGdEpN8dNJRqvNli3TaZunjtl/oaiEyzocBRFc68b3318uX79pntOiaJay7XN6tePrYm7vWHetGo/7zklqnX4ujOiqHrKaxdPiQ9RW84eOttgdszjRqrL1UaqEsN489yofrTrms3/bqq1KBp7FLKdSZ5v5rEba7mgY/mHCHZjPL9dVzgI5Xc/sGL+jOpBxy6tuMM3zw2eb8ODVq+W5APa3HimNyt8jOKrJXmgMtsUjHxOt3N3H/tyxfwZ4z8IG+ZNix+Uudc1vOqau1bzfwpKPnyBMV8xf8bYycbHTXZg7eIp9RdM5vGt9T/+dbdu04Hrzqie0T2nTFu8YtM9p0ybe0qtG3NPOSO9fXwKY+PZ9C80pZRSY3XpV28ZfeXIHT/+dW595esrAy82+MrXVxbtOPrKkUu/ekuZQ8w5+/K333777bffnnP25eGVgUPMnjR5z123PjF7WqC+8alPxs1WW/7Gpz4Z3mXPXbfOnjS5aOhqmeHR517PrdU/2Hj9osXr169/4oknFi1atGjRomefffa+++47/zNzn/zWw/9+6fK7/mHhw5/81r0fv+rHZ39z1YwFqd1XLJgxdcE9F0+bcfHD95wybfGKhxdPPeOeR285d+qCjSsWzDjllrFtqguPPrfx4mnnXl+3MFbXnxGdcsvrKxaknt177vXVBhPb5JzFLedOXbAxs/6eU8b/j37xw6lvbbx4WrKp+Mv69becG01bvCK7V3r964/ecm5qTjp1wcb0ZvGXDy+eGo2fe205c+hsg5lTiKcs4ydYa+T6M6JofNxyOjy28YyLHy76bnaUilaOt/PcPaekhvrhxVPHWi7oWP4hGh2xftAyg1B+97iH8SmMLVx/Rjzguefb8KC1n47qVLXJ8cxsVvgYxZd63U9TiW1CI1/f7dzdx75M/GjHG4wvhK+65q7Vgg638vClVm68eFoUnXFP7bg5Hcgb3trvnPjotV9Q158x/hMxbfGKsX9ff/SWc5PfTQxdrcMrFsyoLiROQSmlVBN16VdveWHnkbt+8pvcSj7vP2vO2ZcX7fjCziOXfvWWukP89De5Nefsyw8dOnTo0KFUIIlXFu34ws434kNUM8NTn5j55Gkznzpt7N+nTpv51Gl/9dQn/uqp02b+y1lnxG3G5px9+b+cdcZTn/irpz4x88lPzHzyEzOfOu2vnjrtr576xMxqVTND0dDVMsMPnj+YW//yL/+yevXqDRs2fPWa6350yY0Pnfa1K6+88oc//OGSJUvO/fQ/brvnifWL7tl01dr7P3ntv59+66oZC1K7Lzpz5iWPbLxk+sxLrjw3OnPNDx5ZMvXMNT+49dypV25ceeXMU289+IPnD1YXFl25ZOXzGy+Zfu6i2o7JdqKp02dGZ65ZdGY09cqNY2uu3DjW4Pg21QbTdeu51V1K18ZLpiebir+sX3/rudH0JSvr9pp5ySPZ9XlrsivjLx9ZMjUaG4TEcvjQuadQN4CZ81pzapS7nDjE2KHXnBplm8qOUsHKWldLfivZmdxDNDpi3aDl9rzk7tXOnLvokSVTx0d70ZnRqbcmm832sMxBkxWfb7nxzN+s6DFKnEXjbiS3aTjyqWsmu/vMSx45uPLKmdGZa37w/MGVV547tfqjfeu50dgPbPiqC1yr5a/GFh6+zMpHlkyNolPPjK/VbAfyhrf2Oyd1uHMXxb/cHlkytRotpy9Z+fzGS85csvLWc6deubH63fFfjxsvmR7Fv75WXjkzXl50ZjQ+kkoppcrWZVfd8uKuN773+JbcmnP25fuKzTn78qIdX9z1xmVX3ZI8xOrHt+RWw0MU7fjirjfjQ8yeNHnv6uXPzPm7TP3tM3P+7pv/OCd5lNTyN/9xTt6Of/fMnL/bu3r57EmTi4aulhl+NHoot77+9a8//PDDGzdunP+Va39y4bKNV3xn3rx5TzzxxN133332KZ/+xZfvXvl//NODf/v126dc8IOPj9wxc0H97veeGp23ePTQj0afvXR6FEXR1IXPxt9dtXDmqbeNL5x1XnTWvT8affbS6dXtD61aOHPqwmd/9OjI1Okjq0YPLT4rqm78o9FDi89KNPXoyNSz7o3Xx9vU1W3nJY9bop69dHoUjTe7auHMKHEWiUPce2ryjG47L5o+smp8/fhm91668Nn6NYcWn1VtLbny2UunR2O7PzoyNZp56aOND51pMHUKY42kzivea9XCmeMdrh4osf2jI1Oj+i2T3x0bz1SXcg7xo9vOS+6YOJ3U6BV1LPcQwSOOdT4etOwglN99/KI667y6R/ms804dH7e8HpY4aOKi/dHovaeODVGJ8Swek4LHKD5E9gpJVWqbvKPkdzv/EKsWzhz/iR77aV21cGYURVFt6MJXXelrNXQ1tvDw5axM9TzdgdzhrY1/9noYXzP2y+3eU6ePLF54Xrzm0rNmnnrW2CHGfqfddl6UNvbdqPaIKKWUalyfu/rWzft+e//63bk15+zLdxWbc/blRTtu3vfbz119a9cOMXvS5P333bHpwtN+eeEnf3nhJzdddNqmC2uVPMScsy9feu7c1JpN8S4XnbbpotM2XfjJ6o7777tj9qTJRUNXyww/fuFIbt1y50NXfOGLTz/99He/+90vnXvZ586f98ADD6xYseIzH//0yvlLfzZ/1fdOueonF3z7J/98y0OnXLvq//xq3e6PjXz4rPt+/MKmy6ZHH1646ccvHFly1tjCj184csfCmR+7fWwhmj5yxwtHqltGURRF5y15bOTD1X/Puq+648cWjnw4iqIoqttrfIPqNkXig5arTZdNjz52Vvz/6fOWJNffntzyvo/VDhJvduTHj411tbaytibRwu3xIWZetvC88UE4ckd1jhJFHz7rvA+PtZA5dG6Ddacw87LH8s7r9rovo/HRSzYYRZl9b0/MWsZ2iR+s5C71K8fPKK7kY5R4UIo6lnuI8ElVTyQetNxdSu5eO/HEBvd9LEoMWs75ljlo7SFONF5yPIvHJOcxivucOKP8Sm2Tf5S8bhceYslZORdAugqvuuC12vBqjI/b1MOXGPP6s9t02fT6c6nrdt6vl2QP09ft2FjdsXDmhxdu+vEL931s+nkfq3Zj+nkfmz7zw8XXz/guDa4upZRSRXX51bdtf/33jz53ILcW3fj9wOsZFt34/aIdt7/++8uvvq1rh5g9afLr69a88PlzXvj8Z8frnPEvz7nxooviBm+86KIXPv/ZzJpzEruc88IVY+28vm7N7EmTi4aulhl+8tIbuXXL3Q9/7Wtf27Fjx/bt27ds2bJr165f/epXo6Ojs2bNenr1Y88tffCJ+d/5wZx/Xfa/fnrZ/3b22lVP1+2+/PwPf/m+y6ZHH1ser3zusukzL/vy+WP/K/3hGz956Y2Rz8y87Idv3PnlmVEURZ+5L969uqa678hnokLju4x8JnmgVDeeKzrBvHquvs9KqZZq+fl1P6rTR+7seZe6deLjv3Oeu2x69Rdd4u8Ln7nvJy+9MfKZmR/7zMzssFR/H+Y2e+eXZzb5q0wppVRd/dO1t+88/F7Hm915+L1/uvb2rh1i9qTJR/593earLutQfa66cOTf182eNLmoA7XM8NNfv5lbj23af/nnF3z9618/8zNznn322RUrVvw/f/f355xzzuf/x0VPfv7bK/7ruf/6v5x2+/+94O4vrvrRM/uKGhm0eu5z/z36+PKed0Nl6/6P1wfGJh+mNnfvSZ8ncGeUUkqprtY/f2357jff/9nWtztbu998/5+/trxrh5g9afJbTz++fcmC7YsX7FiyYMfiBdvjWjJ/+5IF25cs2L54/o6x5fnbl8zfvnh8efFYxXvFC289/fjsSZOLhq6WGf79N28W1WOb9n1zxb3X/euK888//5Of/OSNdz96zTdXBLYf/Hruc/89+vi3e94NpZRSSinVsVr4jbvXv7h7z9EPOlvrX9y98Bt3d+0QZ/63v/nFXXf/7lcbOlu/uOvuM//b3xQNXS0zPL75qFJKKaWUUhO17ntyx8Jv3HXFdd/ubC38xl33Pbmja4e4+57HPz3lr2dPmtzZ+vSUv777nseLhq6WGX625S2llFJKKaWUSlUtMzyx9W2llFJKKaWUSlUtM/x822+VUkoppZRSKlWhzLDs5pUDXccAAIAmNZ0ZKgNLZgAAgBYMV2ZQqjvV659rAIBOGq7M8J+DrDoZ7XUvavSniMwAAEwww5UZjg+s/0zMiXvdl+PH9adRT3r9cw0A0EndyAxRFMX/NvXdol2a3aZKZugg/Qn3pNc/1wAAndSZzBDP+5Oy0/qGwSC1b3Ih1WZrmeG9gfWXv/ylOif+y1/+0uu+vPee/jTqSa9/rgEAOqlj9xlyc0LRPYQoT3av8PoigczQzZGNoijwZXjjrOScuIVjlVnTlEB/yrccb5nbvbCS/UntEm6ktbPI7Ulr+wIA9KdOPjcpd36fmxmye2VbyC7kthNuPJUZ/tBFURSllpNrcjfILseSc+LwsUquyT1KeYH+xCdblVxOjUNyoWibkmdX1J/UsXKbzR46259mR6bXP9cAAJ3UvcxQnX41zAzJzRpmhtT2DTPDuwnJSWF4TXIhd7OU1AbJzZpdjv35z3+uzon//Oc/Zw+Xe+hAD4uOUl7D/gTOvWihaOPcx6Vkf0oeomib3GOFVXvS659rAIBO6vDrGQL/phbiuX5UcJ8hu00qGwS+VZQZflcviqLwQrUDqYXs7lm57aRaKGoqt9nknDh8CuGONbVNQKA/2ZMtOvHAkKaGPfe7rfUntSbcbAtkBgBg4un86xnKZIbwytyM0ZHM8E69KIrCC9WTSi2800jJLaNi2Y2Tc+LcRsInlW22zIkEFPXnnfqhSw5F9oiBPqTOqOgcy/TnnbwxeSdvfFI9L3oswmQGAGDi6errGcpkhqpwlgjkinBm2F8viqLsQlXyy+RCajlXbgzIHjS3J0X+9Kc/VefEf/rTnwK7p9rJHjfct/IC/YkPlHvQeJsi2Q2SLRf1uYXxCYxVO6o96fXPNQBAJ/VdZmi5nYaxYdnNK1+tF0VReCH7b3bfIkUt5O7YsLXknDiwb3YKXnSIhkdsrT+pQxd1oOjo2QcibjPc+UB/ki0UDU6gS82SGQCAiaeTz00qmrgXzfUbJoTkNtnts8KxYdnNK/fWi6IovJD9N3f3XKm+hVsLf7l3797knLjoKEU9L3mIpoT7k+xYw6PnLodHu6nxyTZbNFapnqdOoSSZAQCYeDr5GuhK5oZA9rvJGX84P+S2EDh0Q8tuXrm7XhRF4YWif1MbZ5utKtlOwy937979xz/+sTon/uMf/5h70NS+2RZS64s6X1KgP0UnWDR0ucvJhaJzKdOf3LMOrAwcoqRqT3r9cw0A0Emdf25SUU4oOfVPxYnyOza07OaVOxOSf0gOrMn+m9qmSGr73NZSGxd9uXPnzuScOPdYuX0u2iZ3g6YE+pM88XCXwr1tqvNF/Ul1JtWl3D4EHqYyZAYAYOLpZGboc8tuXvlyF0VRlPo3tT4s1doHH3xQnRN/8MEHqaNkGw8ct+jLZhX15+W8E892JtXzbo5P9qCpI+Z+t7xqT3r9cw0A0EnDlRm2d1EURal/qwvxcsN9k5Jz4pJ7hY9VphsBgf7Ep1x07rkdS+aBht1rbXyyOxb1p+TDlEtmAAAmnuHKDNsG1vvvv1+dE7///vu97su2bfrTqCe9/rkGAOik4coMWwZWck7c675s2aI/jXrS659rAIBOGq7MoJRSSimllCpf1Yn0EGUGAACgvFKZ4cltv02WzAAAAMMjmRlS0UBmAAAASmaG7b9NVjczw5o1a7pzICaYgbtyBq7DAMDwqMsM9dFAZmCADdyVM3AdBgCGh8zAxDRwV87AdRgAGB4yAxNTN6+c0dH9o6P7kwstcKkDAH2rVGZ4avtvk9VmZhgZGYnGjYyMhDfu2kRqdHQ0tTC4OnsK4db6dty6eOXU5YSWY4PMAAD0rWRmSEWDZGZ4J1mtZYaRkahSqVRzQlIURYG9yk+kOj5nPUEz7y7MrUdHRzt4lGZb65PwIDO0oKk8DwAMj0xmqEWDTmaGZGDIfCsUG5rKDH0yW00KdOlE9Lba5ui48rsEFppqrX/IDM1qNs8DAMOjPjO8U5AZdryTrJKZYWQkqlZ15lGdhVQqlahe8ltZTWWGXW/t6vO7DSdIqpO9vc+Q26Wm7D2yefeh3+w6/NLBt3alvnXo7fSaIhMsM0TltHDcuP3qj+GGBLEBAKiqywz10aCWGX6x4524SmaG6o2FSiWqznYqdTcZokolGhmJ/w3damg2M5yI2NCaZv/M3/1D96S1hvYe3rzt1dFXXntx277RHQdeeOO3++JvHXn71ZcPvfDmO6Vm5BPsNdBl5u4tP6EovrFQ/TIVGzxJCQBIZoZkNPhFUWb4RROZIZ7l5GSGODZUOp0Z+ic2dMHEO9Otr47ufO2lSqXy2pHt2/ePvnpo66G3du8+/OuDb+7aeeClHUdG9x7e/PobO/e9vfn1oy8H2glcOfv37x8dHd2/v8HkvtkbLA0bDCufGTZs2FC0TWvz++qOcbMb6nltAwBwojJDpRYbxuY6ycwQRVH8YsvKCcgMnYoNo/Xab3BItDNuL+9/cffrv6lUKnsPbdm+74VXD2579dCWHUdGt+0f3X5gdNv+0a2vjm57bfTlt0Z3Hngp0E7gyolfpxGY5Sdf1FEmDKRySAt3Hkpmhqj6NKXKWI39d3ybNjNDSqVSkRkAgErJzPD0jneSVfI+w/jTkyrxE5CSmeEEvZ7hxMWGZvdqqvF+ziQtj0BrJ7Xv0Pate0e37hndvveFl19/Yf+h7W+/c2j7a6Pb9o/u2Pfirtd+/cprL24/MLp17+je17cG2mmYGSrjeSD1EIzmCceGZCP79+9v7RUOZTLDWESof7FyHBvayQzZwCAzAACxZGZIRYNEZnj5nWSVu89Qez1D/DLoE/2+SanM0MHY0H4jgcbbCQzdSRqtHaXlvu0+8Jsdr7746utb33z79Tfeem3Xgd9sfXV0+94X4g12vvbS1r2jr+x76eAbu4saKZMZ4uXjx48fP368Mp4iqhkgtb5htxNR5ERlhuQ7GsVPJUq+u0AH7zNUKpX4ZdBFzXb2ddgAQN+qywz10aDNzFCJn5U0dsNhfEqR+36OHX9uUjUwVOd/JVvINLg/WyeinRbm1p3q24noYQf7dvCNXVt2jW59dXTr3tFXD26L1+95fcu2/aPb9o1uf/WFQ2/szd23fGY4Pq5Sfwui0n+ZIflldh7fTmZIxobqymRgCDQrMADAMCiVGda//E6yymSG8QlEVPcC6BaAPgoAACAASURBVMSrF+JpSiX4njDtvJ6hncBQqVRGR/fveuN4slrODB1p58S12bC1ZjPDH3btTVY7fTtwZOcr+17asnt0++7afYZX9r20dc/ojr0vvn6k8K1Xw1dOMhsUZYbqmvKZIb470YXMkHt3rrXMEIf21N2GMoEhbkFgAICJLZkZUtEgmRl+l6yS9xmixEszE1OKnIlOoJGW3zepzcBQKZhJt9Bmp9o5cW02bK39zNDO+b52+JUte0a37BrdvufFV/b+evueF7fuGd2ye3TXq5sDe5W8curuOYxP+gPrSzpxr4Guqr7MILtNs5khGRiyyr/RqsAAABNbfWaoiwa1zPDMK7975pXfrR+vZj6fIRsYxhbiT3yLX+2Qq7XPZ2g/MFRkhr7JDC/vfXHLntHNr4xu2TW6eefo5p2jW3aNbts/un3Pi4G9mv0E8eyrStp/eXpTZ92Rz3RrKjOkAsNInvKtAQATWDIzVHPBM+OVzgxxlc8M2TsM409YqpygzNCpwFCRGfomM+w7uP3lV186cGjntl0vbtkzumvfb/a9/vLuA79JvsIhq5uf6Zar2XdfbSozVJ9ElHyaX7OZITcwNHeGAMDQSGWGZ3Izw4ZXfpes8s9NigNDHBsyk5xQYKg0/9fiTgWGiszQN5khtv/gK1t3jR5+89UyG/c2M7Tw7qs9uc8gMAAAZSQzQyoaJDLDzt8lq/xroKPESxpStxfCUSHWVGboYGCoFLz/T2uZoSPtnLg2G7bW/vsmdepxee3QzpJb9vw+Q6XJd1Jq2OHc5w61+WwigQEAKKMuM9RHg7rMsDFRzb4GOv6y5L2FpKZmfh0MDHGDWZ1qqn/61rC1Zp/Q39m+tWbiZYYTRGAAABpKZoaN9dGglhk2tpQZOqIfZn5Drs3XAfdKP1w5+5t599V+6DAAQK5SmeHZXe8mS2ag//XbldPma6ABAHoomRlS0UBmYIAN3JUzcB0GAIZHqczwy13vJktmoP8N3JUzcB0GAIZHMjOkokEiM+x+N1kyA/1v4K6cgeswADA86jJDfTSoZYZNu99NVjczAwAA0FvJzJCKBrXM8Nyed5MlMwAAwPBIZoZUNEhmht8nK5UZ1j32U6WUUkoppdSErExmqIsGtczwqz2/T1Y2M3Qt4gAAAF2TzQypaFDLDM/v/X2ycjPDsR5Zs2ZNU9tXfPAtAACUk80MqWggMwAAwFBrIjOMvvqHZE2YzBCNjESt5oeWdwQAgEGRzQypaFDLDC+8+odk9SgzrJsXRVE0b1392jbvM5j6AwBAkWxmSEWDWmZ4cd8fktWTzLB0VjRv3bGls2QGAADokmxmSEWDWmZ4af8fktXD5yadiMyQfYZS0Zp4fWqD1HcBAGBiyGaGVDRIZoZjyZpgmaGFhUrmBkXuNgAAMNDyMkNdNKhlhl+/dixZEz4zZG8a5N55yP1SZgAAYMLIZoZUNKhlht+8dixZEz4zpEYqNwbIDAAATHjZzJCKBrXMsPnAsWRNsMwQePVC6svsmuyXXtUAAMCEkc0MqWhQywxbDryXrF69b1JCLTl04TPdAi9jAACACSybGVLRoJYZtr7+XrImzGe6ledtkQAAGELZzJCKBjIDAAAMtSYyw7aD7yVLZgAAgGGQzQypaFDLDNsPvpcsmQEAAIZBNjOkokEtM+w4dDxZMkNzomisym/QcJdAO32obzsGAEBQNjOkokEtM7x86HiyepQZ1s0be9OkWUs319b2dWYoP1fOblZmx9Q2fTsv79uOAQAQlM0MqWiQyAyHjyerV++1OvYGq+vmRbOWxuv7PTO0vKXMAABAr+VkhvpoUMsMrxw5nqxePzdp3bzuZ4b4yULxrYPsmty9Ak2Ft2w4zy7zjKbyT4uKt8k9r9aOlRyr1JeBMWzteVkAAJwA2cxQTQQ7j7xfXahlhp1H3k9WbzPD5vrPgu7f+wxFgSH73c7eZAgslOlPIM9ktylz0NRCNh6EjwUAQO9kM0MqGtQyw64j7+868v6uN96vLvQwM2xeOiv5xKRjA5cZKgV/jy+5b2Cbopl9w/sMRQvNbpO9XVB+IdAOAAC9k80MY9FgvBKZ4Y33k9WrzLBuXpQKDMcGIjPkxoOOZIZwy+WDR5nOZLcpuVf4PkPuXgAA9IeczFAfDWqZYfcb7yerV6+BjpLPSRrX15kh97k3RZX9bpn2Uwdq6oUBRUcvOlDDNakUkb3zkHvW4XYAAOidbGZIRYNaZtjz5vt73nx/93j1IDNsXjorSqqlh/7NDP3P1BwAgKBsZoijQXUhmRk+SFav3zepjszQCn/OBwCghLzMUBcNaplh79EP9r5ZK5kBAACGQTYz7H3zg2Q6qM8MiZIZAABgGORkhvpoUMsMrx79IFkyA0TRRL6KJvbZAQDlZTNDKhrIDF1SfVl3zxsss1f8IvRWu9aDlk+E9qfUuWfaVyPQzdjQ/6MBAEOricyw760PktXLz2eIoiiatXRzbeUEyAyVgjlT9xssudeJm8mduG53sOXUZLrjea+DrbWphdgwgUcDAIZTNjOkokF/ZYZ188bfYXXdvOQHNcgMHWxQZiiz1wTLDFE0kqzsd8P7ZtYM9mgAACkDlhlqupsZkp8KkVyTXEitz+5bcpsyC0XtFHW76CxK7pX6N7m+tZYbjkbujmVOrfx55bac7WFRy8mJctFJhbtU0Gxor6Jmsx0uOrWizjRU/m7DMIwGAAybpjLDH/e99cd9b31QXehZZhj7ZLe6j4Puwn2G5CwkXshOVk7cQsNjlexzs3tl/81toamWw3u1MKrh47bQcrjblUb3GUrOR0/QY9ra1RLsZ4s/LE0ddFBGAwCGUF5m+GOy+vU10F1/blKZ+WXJbVJ/HG1qIdBOU31udq/AxKt8y5XMBC73LLItF41YoD9FRw+3nO1h8eFCmSG3nTL9CRwxsE3J8Ql0KfDcpI68nmGwRgMASGniNdA7j7yfrJ6/b9LSWbXQMFiZofxeTbXTVJ+bzQzZXVrLDGU2bjhl72BmKLNla5mhTK86Mktu7cosqbX3TZqoowEAQyubGVLRoJYZfrX393E9v/f3vcgM6+bFb5e0bl40a2n8je5khtQfL3P/Tpldmd0ysCbbfvZbgXaKvptaCE/Ccveq1M+0Ah0uajn3NHOP2NSIZdsPdCC7TdFZlGk5GxsatpPdPvdAgR0b7lW0e5kuhU+wqc0GazR8EgUAhGUzQyoa1DLDk9t+++T2WvXmPsPYixmi7r/XavmZVj87cWcxMcanWd2faw7nOBfp1GjIDAAQls0MqWjQZ5mhQNfeN6mDQ99ZDf+wWsk7izJ7NXX0jrfcZn/65IFrrT/ZvfrkdNrUb6MhMABAQzIDAAAQIjMAAAAhMgNQlqfxAMBwkhmgLW0+pT71pPzcpvrqNQwtfL7bUI0PAExIA5kZNi+d1f3PgYYiLU9Yy+/YV3PiNj8W+kTs2FfjAwATzyBmhnXzZi1NfqDbMZmBnpqQc+LAJ0NXGsWGkh94V6IP/Ts+ADBUBi8zbF46a966YzID/SP7/JkybwOa3Sx3l3BTRcfKbTa1WdvPGir7EzSc4wMAE8mgZYbNS2fNWnrsmMxAH0nOPosWwjsWrSnTTpmj506ay/Sw+KDNfbxJw4XwjkVr+nZ8AGCCGbDMsG7e2Mc/ywz0j36bE1eaeelw8V/oR4qem9Ty6xkm0vgAwFAZsMywdFbiqQazlsbrZQZ6qN/mxGW60fLf0Vt4u9WhGh8AmJAGLDPE3GegTyT/Gp1aaDghzv61O7tXdrNAB3L3Ktq9Yct5xyr1U5PcbMKMj8+mAGCYDWJmWDev+r9x9xnoV+Vn4YN1rE4ZxPGRGQAYZoOYGXLIDPSP7N+tG/5Ju9mWO9VgTwzi+AgMAAw5mQEAAAiRGQAAgBCZAQZJb58k4yk6ADCcZAbojK69rqDlibtn9gMArRmwzLA58QENY5/uduzYMZmB/hCekXcwUbQTG1r+bvtHBwAG1OBlhmRUiMkM9IPOZobAJzFXGk3ci74rMwAALZAZoAOK3j80sEF2m+YP2sQ13MEepo4rQgDAhDd4mSGe2SQ/CFpmoIfiWXVgoZL5K37uNs0ctLnA0MEeCgkAMGwGLDMkrJuXSA0yAz1UNP/O/iE/u2PgVkPguUnNzto720OZAQCGzeBmhmNLZ8kM9IUu32doYcruPgMA0I7Bygzr5sXvlrR56axZS+NvyAz0VpRQtCZeGdirxIFKXbd5r5nuTA+bfTU2ADABDFZmSL6goe610DIDdEFuPJAZAGDCG7TMUEBmAACAE0RmAAAAQmQGAAAgRGYAAABCZIbmRCMjkbABAMAwGcjMMP7eSbW3TurmfQaZAQCAoTJ4mWHprPq3WT127JjMAAAAJ8ygZYZ187KB4VgnMkPySUfV5ezTkLIrvTM9AAAT3oBlhs1L582bN/bMpHnrauvbzAzJtFB+AQAAhsGAZYZ18+KwsG5eIjW0nxlS9xBkBgAAqBq8zBA/Nyn5NKVO3WfIrpEZAAAYcgOWGY5tXjpr1tLq4rp5HbvPUKl/rUJ2ObVNbY3XMwAAMNENWmY4dmzz+DutJl/Q0KvPdJMZAACY8AYvM+TyOdAAAHCCyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhHQ4MwAAABNMJzODUkoppZRSakJWZzLDCXrSEQAA0HMyAwAAECIzAAAAITIDAAAQIjMAAAAhnckMAADABCYzAAAAIR3IDMtuXqmUUkoppZSaYNXhzNCFcAMAAHSNzAAAAITIDAAAQMgJzAzrHvupUkoppZRSaqDrhGeGjsYbAACgq/orM4yMjLR5Pp1th7DqJ3qU5EHpFMMOALSjhblE9zJDmY+Uq/ap/Y+mC7QTRVHR+iLt92cCK/l4rVmzpoUHJWDIH5d2hj05dEM+jAAwtJqdSwxIZli3dOnm6tLmdes2N9VOIAwkI0HRRMqkKqwjk9fcR+FY3mMXbzPkj0v7wy4eA8Awm3iZYd28KIqiWXFmWDor+WX5dhokgexstWhLktq8z9AwBhTliiF/XFoe9qLrHAAYKhMsM1QTQjYzNIgNufOkbGZITkPL3Isgq7XJa/kBlxlytZ8ZXOQAMMwmVGaI80FeZoiieevKtJN7x6BoJhpeJuvE3WcoyhIyw7H2olq8nNxyyMcTAIbNRMoMiXiQmxmKQ0MLr6Uu8zdvstrJDOHkFt5myB8X9xkAgHYMVWYofHpSdp7UMAxE7jO0pP3Ja0rJB2LIH5eOZIbklkM+ngAwbIYqMzRxnyHwB+z4S/cZWtDmc5Oqcgc5MPIeF/cZAIB2TKTMMJ4PMtFgbH3xq6BbeN+koi0Ja23yGkhoRfNXD0qS+wwAQDsmVGYYf6PV+tgwtq6J902Khaek7jO0oP37DFHwjVY9KLncZwAA2jHBMkPiuUjV2JAXIsq0k5oVhSdJ5k/ltZMZPCgtc58BAGjHhMsMx44dq38RQ6PPc0u3E5iJxt8K/D3bn2DD2nluUu6WHpQy2swMhhQAhlyfZoYRhlv1gqPLDDsA0I4e3Gcoo9qn9nWqHTpow4YNve7CMDLsAEA7qnOJ3jw3qehZECOZ5yatKaGSubciM/Qhk9eeMOwAQDt6nBlyY0NuZrgi6PDhwxWZYRCYvHZW8MmHx44dO1bdzLADAO3ofWbIxoaizBA4jROaGaIoyl2Zu56w5OQ19dLb5JredXDAyAwAQBf0RWZIxYamMkN1flkyM3R2Mmpq24LU5DUew+Rgtjaww/lwyAwAQBf0S2ZIxobymSH+m7TMMChyM0NqJGWG8hr+NFU3kxkAgHb0UWaIJzqBzJD6a3RTmSH7vJfUE2Ny5X43vFdRs8k18XJul4o6MwFkM0PuQKX2Cg9mUTvDIPcHyn0GAKCz+igzlLnPkJpqx3PE1u4zlJxiFu0VThplFlpoedC1cJ+hzGBm9xoSqWs+yrw6qLqZzAAAtKNfMkN2rh/IDNk/Krf83KQyf5zuSGaoZHJO7u4T/u/lRa9nCKwsM5hFTU14xxqpbiYzAADt6IvMkDvXz80MlYJZdZuvZwhPN0/cfYaGe008HckM7jPEZAYAoAt6nxmys5yGr4HOzg7Lv9dq6i/9Df+un7tBwx0b7lW0e5kuDbTc91rNrsldn2yn5GYTnswAAHTBwHwOdA8/n6EFwzZzLc/ktScMOwDQjl5mhiK5meFwI9nGm80MDW8ClNxrYt8oaJPJa08YdgCgHV3NDCNdtwEAAGhb9zJDSZ16TlEPn5tEkQ3+4N0Lhh0AaEe3M0PLz01qKNu4zNCHTF57wrADAO0YmMxwRVC/vQaaIiavndXwp6m6mWEHANoxSJkhcBoNM0ObL0pOvaw5tymvey5jQ957rcZD5+XjzZIZAIAuGPjMUJ1flrnP0PJMtPyOJrsNbSj4TLeo7U9nG87BlxkAgC4Y7MwQ/01aZhgUuZkh+3ltLbQ8nIMfX+2pmzYyAwDQQQOWGbIf+ttUZkg9v6jMM2Gym+XuEm6q6Fi5zaY2m2DP1clmhtxhSe0VHrqidoZB8oLPBgaZAQDoiMHLDMmJdTxHbOo+Q2AhV+4UNtxyoJHwQgstD5YW7jOUfOAmzBA1JXXNR5nPVq9uJjMAAO0YyMyQ/aPyIGaG5OkEdp9gf0Evej1DYGWZoStqasJr+NNU3UxmAADaMWCZoVIwhx7EzFCmG0NynyHFfYbyZAYAoAsGLzNU8maHJd9rNfm8pkpB/EjJ3tbI3Sv37kfuBkV7Fe3esOXBkvteq9k1ueuT7ZTcbMKTGQCALhjIzJDV2me6dXN+OWxz2SImrz1h2AGAdgxMZjjcSLbxcGZo+Efulmf5uXcPhvBP4LlMXnvCsAMA7ehqZhjpug0AAEDbupcZSmr4nKIut0MHbfAH714w7ABAO7qdGVp+blJD2cZlhj5k8toThh0AaMfAZIYrglp7DTTdZ/LaWQ1/mqqbBYa9+y+z8cIeAOgfTc0lBiMzBM62fGbwWuTe2pD5fAYvEG9Hm5khyryDcHceCA83APSJYckM1clHU/cZwvMVs5kTakP95zPkLlNeO5khGRiyK080jzgA9IOhyAzxn0VlhkFRlBloTXy1p97Vt2Fm6IfA5gIAgJ6bmJkh9+MUKqUzQ9FnMgQ2yG5DO8KZIR7qwEKl4Ik02Q0qQ/DYJS/4bGAoygzZKzzVbNceiIn96ABA/5uwmSE5BYknHGUyQ3IeU7RQKZ5Omdx0RMP7DLmPTpk5bsO9JqTUNZ8KDEWZoVLiPkMXHohheIAAoM+lphDZhepmA5kZsn/abC0zVDLZo1IwDRqSCWgXtJYZcjfLfdSGLeM1/Gmqblb+9QyB73b2gRiSBwgA+lxTc4mByQyVghm8+wyDouFroJua/be210TSTmaojI9S9x+IIXl0AKD/TdjMUMmbcDT7eobUEyeyfyvNvRdhotO+ovdazV1ZNPINH7XhebzazAyVRGzo2gMxDI8LAAyKiZwZsnym26DwmW49YdgBgHYMTGY43Ei2cZmhD5m89oRhBwDa0dXMMNJ1GwAAgLZ1LzOU1Kn7A+4z9KEN/uDdC4YdAGhHtzNDy89NaijbuMzQh0xee8KwAwDt6HFmiDIfQVWUGa4I8nqGQWHy2lkNE3h1M8MOALSjN5khKv6ouUBmiLub/VdmGBQmr50lMwAAXdCz+wzVkJD8t2FmyA0M1Rc6ywyDwuS1s2QGAKALevncpPjznnLn+tnMUMkLDNWNZYZBYfLaWdmfptTPVHUzww4AtKMHmSH3w2WTE53AfYbqXYVKIjC4zzBYTF47q2EIr25m2AGAdgzYfYY4JCQDQ8V9hsFh8tpZqWs++9NU3cywAwDtGLDXM2Q/sq16DjLDoDB57axjjVQ3M+wAQDsG732TsoGh4j7D4DB57SyZAQDogkH6fIbUeyVVEi+GlhkGhclrZ8kMAEAXDMznQPt8honB5LUnDDsA0I6ByQyHG8k2LjP0IZPXnjDsAEA7upoZRrpuAwAA0LbuZQYAAGBAyQwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhMgMAABAiMwAAACEyAwAAECIzAAAAITIDAAAQIjMAAAAhHQjMyillFJKKaUGuk5sZgAAACYAmQEAAAjpfGZQSimllFJKTbDqZGYAAAAmMJkBAAAIkRkAAICQ1jODUkoppZRSakiqlczQq4gDAAD0SnOZYTkAADBk3Gcg3zH6TK+vCABgeDWdGd579901raru3nLt2rWrnd1PUPVnr9o/o17PkEnr+YWhlFJKqeGs1jND1BKZYSBKZuhPPb8wlFJKKTWcJTN0oPqzV+2fUa9nyKT1/MJQSiml1HCWzNCB6s9etX9GvZ4hD53qz0hgg55fGEoppZQazuqLzJDa5r13361EUSWKslv25+y8P3vV/hl1ba4cFl8YRWuSF092m+rK3A2y/+buFThix8+0Uqmkmk0eqOcXhlJKKaWGs/oiM7z37rsjIyPxNu+NZ4ZsbOjP2Xl/9qr9M+rshLg1RbP81HdTC+FtslsWtVNyoVOiKNqwYUM1NiR/ZGQGpZRSSvW2+iUzJLd5L5EZUrGhP2fn/dmr9s8od1Kb1dl5c/aIyUMfaz4zZDfObhmOHLlbnghxZhgZGam+qVl1QWZQSimlVG+rxczQznu7ZjsR32SoLrznPkOvK3CfoWRgKJpnJ/cqaid7iEBrqV1S67Ndyj1QwzW5R2/fSL1qZtiwYcPIyEhyQWZQSimlVG+rxczQ2YoDQ3X5vcTrGaor4+rP2Xl/9qr9Myqa6Za5wxD4K35TC+UzQ24j2S4VdbLhmuwhGg5CQ1FGNSdUfxziFCEzKKWUUqonValUtmzZ8l5fZYbs+vi2Q1z9OTvvz161f0bhyW75CXHuFDnVTu6f9o/VT9kbZoZjeZP+QJ8DDWa3KbNxm6LxW21J1TXVDXp+YSillFJqqOro0aM//OEP32vn9Qwd/BzoeG6UXBn/tTW5sj9n5/3Zq/bPqP0Z8LFyM/LchYa7BHYPb5ParEyDZbravtzMkExQPb8wlFJKKTWc1RevgU6+niG1JrVlf87O+7NX7Z9R+zPgY3kZIJ4EZ5eTK5NT86I1RW0GtkltfKw+A2Q3SG2c3LLN8ckdsWzLyTU9vzCUUkopNQyVfEpSW89NOqHvmxRL3WR4r19n5/3Zq/bPqONz4jKivL/6D4mGUaTnF4ZSSimlhqHipyR14LlJnc0M79V/REM2LVSrP2fn/dmr9s+oa3PllPgy6FUH+lbPLwyllFJKDWf1UWYoU/05O+/P5dPbXQAAAMNJREFUXrV/Rr2eIZPW8wtDKaWUUhO4cp+S1F/PTSpZ/Tk7789etX9GvZ4hk9bzC0MppZRSE7jiZyIdOnTokUceea8/n5tUpvpzdt6fvWr/jHo9Qyat5xeGUkoppYazWskMAADAUAllhp9v+61SSimllFJKpUpmUEoppZRSSoVKZlBKKaWUUkqFSmZQSimllFJKhUpmUEoppZRSSoVKZlBKKaWUUkqFaiwzfHjLEaWUUkoppZTK1lhmaO1T2wAAgAnv/wd3qWv8E5fRFgAAAABJRU5ErkJggg==" alt="" width="661" height="332" />
在调试代码上方有个工具条:
第一个放大镜形(start debugger),开始调试。
第二个绿色三角形(run),执行。
第三个step into ,单步调试。
进入调试代码窗口后,可随意设置断点,方法就不用说了吧~
a 我们要在参数窗口中输入
两个参数值, p1为6,p2为4, m跟b不用填。
b 点击start debugger,进入存储过程的代码窗口
c 点击step into ,将鼠标放在变量符号上可查看变量值
d 继续点击step into 直到单步运行完毕。此时会返回测试窗口。
e 查看参数列表,验证m,b值为8,4。
在测试窗口点击保存,可保存测试代码。以后重新打开时,你原先输入的那些参数值会保存在其中,免得每次测试都要重新输参数值。
对于返回类型为游标的参数,数据不会直接显示,在列表的参数值框右边会有一个按扭,点击之,会弹出一个
3、Oracle中调用存储过程
DECLARE
p1 VARCHAR2(100);
p2 VARCHAR2(100);
p3 VARCHAR2(100);
BEGIN
p1:='dd';
p2:='';
testprocedure(p1,p2,'');
END;
具体案例
只需要定义一个结果集,把东西存到结果集中就结束(这个结果集叫做游标),先创建存储过程:
create or replace procedure Demo(data out sys_refcursor) is
begin
open data for select * from gsminfo;
end Demo;
然后直接执行就OK ,执行的方法如下:
找到存储过程,右键,选择测试:
然后出现的页面,再选择点击运行:
然后直接看结果集就可以了,注意了,oracle pl/sql这个工具,存储过程的结果集做的很不人性化,比起sql server差了很多,结果集在一个很隐蔽的地方,如图所示,点开即可
参考文章