PL/Sql 中创建、调试、调用存储过程

时间：2021-09-04 00:39:40

存储过程的详细建立方法

1.先建存储过程

左边的浏览窗口选择 procedures ，会列出所有的存储过程，右击文件夹procedures单击菜单“new",弹出 template wizard窗口.

PL/Sql 中创建、调试、调用存储过程

name框中输入 GetSumAndSub ,

parameters中填入： p1 in number , p2 in number ,m　out number , b out number　。

单击ok，右边出现建立存储过程的代码窗口。其中内容为创建存储过程的语句。

PL/Sql 中创建、调试、调用存储过程

在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

PL/Sql 中创建、调试、调用存储过程

单击“保存”按钮，可将创建存储过程的sql语句保存在文件中，作备分之用^_^。

接着要做的就是 执行此sql语句来创建存储过程。方法为：

找到工具栏上的“齿轮”图标，鼠标放上面会显示 ‘EXECUTE(F8)',单击之。存储过程此时已经建立完毕。可为什么我在右边的procedures文件夹下看不到此存储过程？刷新一下ok~

PL/Sql 中创建、调试、调用存储过程

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 ，执行的方法如下：

找到存储过程，右键，选择测试:

PL/Sql 中创建、调试、调用存储过程

然后出现的页面，再选择点击运行：

PL/Sql 中创建、调试、调用存储过程

然后直接看结果集就可以了，注意了，oracle pl/sql这个工具，存储过程的结果集做的很不人性化，比起sql server差了很多，结果集在一个很隐蔽的地方，如图所示，点开即可

PL/Sql 中创建、调试、调用存储过程

PL/Sql 中创建、调试、调用存储过程

参考文章

pl/sql 创建并执行oralce存储过程,并返回结果集

PL/Sql 中创建、调试、调用存储过程

PL/Sql 中创建、调试、调用存储过程的更多相关文章

  1. SQL serve创建与调用存储过程

    (1)创建 2编写存储过程(创建传参的存储过程)存储过程语法网络上很多不在累述 语法解析 Use Person 指定在那个数据库下建立存储过程 if (object_id('MyFunction', ...

  2. 在PL/SQL中调用Oracle存储过程

    存储过程 1 什么是存储过程? 用于在数据库中完成特定的操作或者任务.是一个PLSQL程序块,可以永久的保存在数据库中以供其他程序调用. 2 存储过程的参数模式 存储过程的参数特性: IN类型的参数 ...

  3. 在PL/SQL中调用存储过程－－oracle

    在oracle10中写好了存储过程,代码如下: CREATE OR REPLACE Procedure Proc_Insert ( sName in varchar2, sAge in int, sE ...

  4. PHP中通过sqlsrv调用存储过程——成绩排名去除重复字段的数据行

    培训考试项目中,需要实现考试成绩排名:排名参考项为分数(score降序).参加日期(attendtime升序).第几次参加考试(frequency升序):并且,每个用户只保留一条数据(pid). 考试 ...

  5. 使用集成SOA网关的PL / SQL中的REST

    使用集成SOA网关的PL / SQL中的REST Oracle电子商务套件集成SOA网关(ISG)是一款开箱即用的模块,支持在Oracle Integration Repository中发布支持的接口 ...

  6. ORACLE PL/SQL 中序列(sequence)的简易使用方法介绍

    如果我是C罗 原文 ORACLE PL/SQL 中序列(sequence)的简易使用方法介绍 sequence在ORACLE中应用十分广泛,就是序列号的意思,会自动增加指定变数,如逐次增加1或者2或者 ...

  7. PL/SQL中SELECT总结

      一.SELECT 语句的各个关键词的顺序及作用简解(这个我简略点写~) 1.SELECT 2.FROM 3.WHERE 4.GROUP BY ---对结果集进行分组,通常与聚合函数一起使用 5.H ...

  8. 如何在sqlite3连接中创建并调用自定义函数

    #!/user/bin/env python # @Time :2018/6/8 14:44 # @Author :PGIDYSQ #@File :CreateFunTest.py '''如何在sql ...

  9. [转] sql server 跨数据库调用存储过程

    A库存储过程: create PROCEDURE [dbo].[spAAAForTest] ( ) =null , ) =null ) AS BEGIN select N'A' AS a , N'B' ...

随机推荐

  1. 做个简单的RSS订阅(ASP.NET Core)，节省自己的时间

    0x01 前言 因为每天上下班路上,午休前,都是看看新闻,但是种类繁多,又要自己找感兴趣的,所以肯定会耗费不少时间. 虽说现在有很多软件也可以订阅一些自己喜欢的新闻,要安装到手机,还是挺麻烦的.所以就 ...

  2. Oracle函数组的使用

    --1.组函数--COUNT():用来统计记录的条数 如果没有记录,返回 0--COUNT函数可以根据一列或多列进行计算,没有排重功能--统计EMP表一共有多少条记录select count(empn ...

  3. 《uml大战需求分析》阅读笔记05

    <uml大战需求分析>阅读笔记05 这次我主要阅读了这本书的第九十章,通过看这章的知识了解了不少的知识开发某系统的重要前提是:这个系统有谁在用?这些人通过这个系统能做什么事? 一般搞清楚这 ...

  4. Spring中事务的5种属性总结

    Sping的事务 和 数据库的事务是不同的概念,数据库的事务一般称为底层事务 Spring的事务是对这种事务的抽象 我称之为逻辑事务 Spring对事务的功能进行了扩展,除了基本的Isolation之 ...

  5. Cookie和Session &lpar;转&rpar;

    Session和Cookie在网站开发中是用来保存用户与后端服务器的交互状态.它们有各自的缺点和优点.而且,他们的优点和应用场景是对立的.   Cookie 完整地描述:当一个用户通过HTTP访问一个 ...

  6. C&num; MVC权限验证

    前言 之前一直没怎么接触过权限验证这块,刚好公司老平台改版,就有了这篇权限验证.此篇文章大致讲解下 精确到按钮级别的验证如何实现.以及权限验证设计的参考思路(菜鸟一枚,大神勿喷). 在开发大项目的时候 ...

  7. 前缀判断&vert;2013年蓝桥杯B组题解析第五题-fishers

    前缀判断 如下的代码判断 needle_start指向的串是否为haystack_start指向的串的前缀,如不是,则返回NULL. 比如:"abcd1234" 就包含了 &quo ...

  8. npm 切换淘宝源

    由于Node官方模块仓库太慢,建议将模块仓库切换到阿里源 C:\workspace\angular>npm config set registry https://registry.npm.ta ...

  9. Linux系统编程之--守护进程的创建和详解【转】

    本文转载自:http://www.cnblogs.com/mickole/p/3188321.html 一,守护进程概述 Linux Daemon(守护进程)是运行在后台的一种特殊进程.它独立于控制终 ...

  10. GNU风格 ARM汇编语法1

    汇编源程序一般用于系统最基本的初始化:初始化堆栈指针.设置页表.操作 ARM的协处理器等. 这些初始化工作完成后就可以跳转到C代码main函数中执行. 1.GNU汇编语言语句格式 任何Linux汇编行 ...

相关文章