REM############################################################################ REM REM Copyright (c) 2002, 2003, Oracle Corporation. All rights reserved. REM REM REM PRODUCT REM Oracle Enterprise Manager REM REM THIS FILE IS MACHINE GENERATED. DO NOT EDIT! REM REM DEPLOYMENT PROCEDURE SQL FOR DEPLOYMENT PROCEDURE : REM REM############################################################################# BEGIN DECLARE l_dp_version MGMT_PAF_PROCEDURES.VERSION%TYPE; l_data_guid MGMT_PAF_TEXTUAL_DATA.DATA_GUID%TYPE; l_guid MGMT_PAF_PROCEDURES.PROCEDURE_GUID%TYPE; BEGIN l_guid := '0089B8D9A98768A7E670896C666666B8'; SELECT version INTO l_dp_version FROM MGMT_PAF_PROCEDURES WHERE PROCEDURE_GUID = l_guid; EXCEPTION WHEN NO_DATA_FOUND THEN SELECT SYS_GUID() into l_data_guid from dual; INSERT INTO MGMT_PAF_TEXTUAL_DATA ( DATA_GUID , DATA_SIZE , ENCODING , DATA0, DATA1, DATA2) VALUES( l_data_guid, 0, 'Base64', -- data0 'UEsDBBQACAAIAPgVZTwAAAAAAAAAAAAAAAABAAAAeu09+3ObuNa/969gvHsn7U7iV97dNvfDgBtubeMFO2 1n7gyXGCVm1wYWcJPcnfzv90iAzdNG4DjpfunONimSjqSj85Z09OGf9/MZ8x05rmGZzEdmr1Vv7jHInFi6 Yd7iD+NR9+Bs758XH2zHmiB94aCw+scaVK4xEwdpHtI7Dx9rksxyPYHhJHkIv45EaVBjkONYTt/S0cea61 l2jfEebPid70DdoSxd1ZjbhaF/rDWbZ+edM/6cPT87PTljT4WTU/hywp2QP52zGjPTXG9s67gz6Lp9cnp6 dtI8OT87hDIduRPHsD0yLADLCfxYFlReUDiV7whcjTG1OYoWDdi+EBQBCkz3Y23qefb7RuPu7q5uOdpkhu oTa96wtZsGTP27gacMOGF1+NVyvvZ7tYsPU6TpyAlgu4vrEcytdoGhfmj4ZYk6aH7lI6920WrV2/Um/i+n LvRct7V57cK+dhZmXqWZ5t1Yzpw3HDTxLMdAbu1iZpiL+8P2Pvl5cuT/VA1PM43FfN+1ZppjuPB9asNfmo Gr3Bmmbt250Cj4Db4FFVXX1pwJqb64zxmG62m3GDlAC7WLf6C5rjqW5f2jIfQVKEE5rW7u9LEMeIQ11a41 FzX0azRpCPceMnVutnA95OS0dNA1wJfRn/qQTB8m3T7cPzo+zBsf8ha2iszvtYs3DPzBf/30EwOfGc6az4 H2ocxwLHOOTI/5DtPWrmfIJXWhEhS+rfV4tScC2crf1CE7ulSVQV+q7dd+FgZXf+0JfV6WpNHeY2NmXB+2 32d8TX2zkTPLLDCRd2c5f2SW/a7/0fjdQbisYRyenTQmMwPGvLFe7d2vsdkMBbl3DPPJmEHuuMICYJGD9Z XQvdcYSor4Nbt4LIvZBZejfk8dao6LnPwKB36FzN6vDTP1zX1w55rZ0PS5YTZ8OeE2Bsg74AfKQbN+dEaQ VKwZ1ITVOWjVW+eNXPw0jutn9cP8YtfwkEr+VbRiocEV7rBhnJydHBCpcOBNgWf1g/li5hlZNKJ2xEEejQ Cyk03+BaL1UuoLGU0Ciky2SLDVk3NUqn+xQ9Vvbh8ZsHMAZxEpxk7W9yiiCWwQWwqIrVDwM66NJsaNMcmR YKQN/jN/YH62XFDp/1lgmcgcuP/5NVYIaj1S6iRKp5qj32kO+hhWmEcqTKbW3GbeAvxwlPiPccO8JX2iP5 masjAlpca8Y/5alq+ngsbCJSzemN3ZIV7jkMMhEfjG2Yk9ScOno7SqwrVAr3lqY1tdPzJo5qKtYYHo/iJj IRW3jIdqnT++ieEkRo2Xw4Px1zS1kDq1JWHVfMrSTo4oCYtZOy2RPTkaNECDfc/QcqmK9Dh9yt7XIbWHFU oWpijRWhqxGGSRmZGuM9BaDbHVel+iM4kn9/C8eV+jxFPuQEGTAENprmtM3q+pUwY72+8zFye2PcE4/H+L E7SlmW9Dzz2bplsvjFjx6xprI9fmq7A+6TFISre1TZNEm9lTbeOwljW3rI0r9J5GDa85d4C+GHJSpP0TMz bdhW1bjod0RgJTWPNwWEp5cD00fxMngzdvwDLuLswJDgIxnkWc+0ybuI5rDh10Y9wz3hRBwWyBGBvmBb1A Q8sxbg1Tm/kFuLJh2gvPZQ7w7613jJABlQQacHn7HXNF2rmL6wDd/pTAin77c1h9H+xtXOsdmNz/p/4alP 881Lypgmz4WHtfI18x1nQYqgljIzhfgniM4C5RAu198Ex9BbOerEXgJ5GeB8mv/OYRm/drAlbuQrdqF/jv DQErt3ZxdLLfajX3262j/fbh/vE5/NbeP4f/280zHMvZb52f5kDR3LlwP5ktdASz85Bj1i5+qc+s2/1f6v r1zb775ww8PhzG258ZQCsmcsg/PNPF7V38jxzIE8fNhLxhOl/Au+QNB2bV8Ob2fu5f3Pt/A+mufi5L8gJd 2qTqRPeDIFz4EwBNpsj9ZX/IdvNm5ViTSzSzgXxrF7CsKiIxOXXiB+VUw/QcS18QVluB0BEIB8yilulefP A05xZ5PRhVEPKdWq5HwsU68I2hzUaRr7H4LScrqix01dGnkUJCuGH0NlJQu/iw5OfVrwyRTn7l37XvWn2m mbd1xXNAaoRAvkjyZ5UXZbUncbUGXduxIsg4cFy8nYtgwt7Hmucs0DIIzSoKjIKn7Z3rjZWRIKsDiRfU4b jTEzmVbjRZcGTxih0J1QFdicNSQEas/EkYwTgEWfhN7bPDoTj4pNBCkTrdscLBRHi1LHoxJshUeqISjkcp BQQwUQXGlSiPxmyv8lhCOBWH0xV7gip8hcXG5MKOYMUHZdHC8rwsKNRDUC5ZGVYW8z8JLkLzRoT9GytZU0 XuyCyXLXciBT+K3NkCV2xTdG2DhgIiwIvxhETA9nppAgg/ll/9F7mCuejbAH7TymJGLTDKjWBgqWnx1ZEG POgPWL0rkSun1UIQfRC/ZdsKA7bTE6jZ5FICMV1mzMq4MwAl2meVzyVEcx+7gUqPvRICvFF3H2mrEGVDC4 GX+qw4KDV3fqCowF1XgkytV3ihy457I/UTMNgX9httc1YeYqXmWzClGg+Azq/YHm3bvihupa2ijoewbD36 qceh8NKXQTk4g9EwWDzalqKiSlxXUdsqdylwn7Fn8NtYlIswXceyZkgzE5DaKtieYFNjzqWGgU0T4etIGJ TqHiwzPPyyYgN8gZWx6E+FkwZd8dMYK0xcomwB5EhSO8I2AGO/BUs6cgQnOtxKEIERtwArsFPLQEovqyx0 JGm0JEy1K8nqsMeO4GefmuFKaCOwWcHiH4AexOq1zAw+DQdDNXDzqNvzYrerYsOH2q8EZsLiHB8go58yWa 9SShQ8E+hSBeOvkI2eRtcAVvuLOABxWIpeCjdNEG1hknpayYOt5FJcFxgO1LpD5OjjBDLLsyO2jBMmccC9 rDwS8cFGFfTemJrCrnjlc1UY8TBFeRBhVKDcRJIhikpQKg0FL0tflGVpO6sTgGptE1i78ppH2QxLx1JsFo br/GO6xImuEvb7Au54DFYJnlpGEMuI63RQiNpkY3meBC+VMQcCSOmOe2WEKDZgsbfJCYORLNJrDhzSKDOS NUSCQZaTxZ2qa5qAUMql65R0qqChIlaMkPCdslEujHlhEOewLUS5aJr/SwIMjNhP5bjxagyW4lfwCcst+1 CSwXYCP4F4ZLQAfBNE7bMDrBOUMS/BTIQhoeCbcF83Aic4pO+fhK3r1/i4/tyC3+z60LG+++e6uSma/KEs dEvxNG/hhn1NEp+LdoEmGHzshDrpYeggGf2Z0UesoEIvPUsLf+U1Twv7mCU+V+hBdBUP2YKJl0sP4Ruxj1 WgmwYOuxr/RTyyZ7A+k2UXUMIPK68Aq+sDS0cZSxAvqdDPFXKMmwfgTIAomq6nmROU7Cn8LiN3MfMqz0q8 GVqO13VQvKPIZxzGjW+8QmMbfgA32AsP4fVj0L3tINe/tPPzXz7G3757rDHIX9lQAPpXcbrs+XHzTDg+Om yeN9s8JzQPm8enZ9z5SfO8fdxqJ7drpf5wPBJUcSCOVH4Y37FNlIXKwIbhzmZoNpxqLmL80LOLx4avgtQj +7wFxshmj3FimbrhBVMGhL/XTP1t0EHcVXvcDz4vHdZHjJvYJPHGjSKMQDQqymVsivESMsHlGujkVo7x3V +F5b/CEcGkx/Kg61hzfEbj7R4fVnAbEqEQJvKF3JhihpGrSI1Wk1whatWbjYVp3DcUfMuFgWHskbW9RxMg AH7Vq49A3eKw8TG2czHaycYoAnzipVgCqoCga8MkN8yCKuEY6yQmxM31nmGiK81x69E9ZqXmH8lZEkq2+/ mIKaxwB+IA9CU0JYGKFXyfJuvhvg0dTNC/g5Gvv0OIq0tRVJCillSHVXy1vholpiIg9InmvV0OObrR+LjP BKiKBzcwgVMNI2Mb', -- data1 'KoWrjEqPvnyKsgH8O+CORkwKbBIKkU3YAkKBKyC4VoSJYeeTbVj6t+BtvoC0zJKRhdmfCpevYuBVDNCJgb htkCJvYRfGwPASLwEeCS5Xh4LcF320BltRUdrfVPnZJIpvzjJjFznMEDlzgxiIbkX50i1hO1wJstj9tvJb o0giW+Jcnye+YAyxhVvRyJm4/5yQM7FCOs4hsR2yMV5cdiUZ5nnoA3vJzMIl566rap9Wsxh1RJIGAOd6hp lLMjhKwJKIWQFKyatc2/FC5rtmibjEW39locZ3w1oQXxzctv28SEkBj67VKmgYkdQJwtd4L7LwW1SlX/Iy qUIEmSp2U3Vh7viIFQ7FgMAl800NqF1gQMEC8qLyefMyp2vVCMrxEC7c6YdG+PsHUC1Y//g//O4u0GRqMT XifGN64A33D+bGcpi5tTA9BmTkArmM5jF7oT7KD4Y/7tWyrsswjN9HmLLhgZlrD4xpeUAL+MAaAPemhsvY lgE93k2NyRT6JRU05kYzZjgHx1syQsZdTCYI6Uh/V1/bF8h3fEodz0hj8ElxhlAag29KTFEgS2Ao75kC08 J3JPzmxg1pHiCUmWrmrbt+IGJGi338CeaEr/LG0HxneFMfFzpeBtzAnVqLmc5cI+bGuEd6Xmczt8hE1g00 oNlQ1ulkMNbCI0OOjti01g0aBvghuJ8PlJZghp2LdI7kamGWlFdRmh+WjBMQ2TKUgX05WcCHz8OPSeGSqE Mjp4mxRczfDFm9jiio1HrsUO/u7fFtKKNteOMpyjgq7WVmGNq4r8KGdn7lv5eh3Tp+NbRfDe1c6jh5NbSf 2dA+fWmG9tmPbWinDyb8yPZ1xmx+KLM6Y/yv1nQ1kX3+o1rTGbTwakTTx7I3KRS2qE29uouQbU/jM7/Bdd u0/RwpfK79ruAABCPiW+Y4vRkefEXmKrulHe47iYORLClDgSOHOJPclV2Ldo8rwURBAtUn8lyHsgRm/Ogb uRpAz3l7jYnj4v9F88aq245lI8czEHFqaIYRPeqfnOqqiNK4S5yKKnLSpcVRnHTpSSy/XHNynDzrzEu6Vn j6Zdd6yrIfGJKci5GH/ap+5xNtIHPS8JtK/oIxJtI+xIto2SpTvURy1AapNHGS31D0qLY2+UO7Re6zbyEX U07LI+F0wKHBiFgCW1O6z+xJk9N3s9n2iH0r28m4AngXYYU8pxJQ+K7IMYuQzFJ8kiqk5RRotC1y2E9yEq VeWN7JBDSB7JTkb0kGyL3/+fQMlqRyEB8LbeYrog1qpru18wlryGgT0QRtitCOh+69izwAI7AyPzRIlQ+N FRJ2zvaEUhh8yJdRZpbnMsR5p2N9Z2GyLk7irlvpZWs3Cyxb7Kz024xLxYW422/kXwXpScBNfswnuVY51W g5/geMlvqLHfoInGXeMP6rANtc79aO13s85IlXnrnKQWHpI3PCF3/1/FhdzmpvuJRNadWnug6u+KU6zr1v TXkwLfvS+zqizm7yEih8q/Z6u71jUiaGejYhk6KtmO8N5E0a1uTGbTeCnHR1mNDND2Kur8un8HwW/P5eFJ V77/5+rHC4M1boAml1slkhUrQ9VrgBv+f6lfqrUD9B4buXY+HgG39kbwabOMbtwqE0cDZ4Iu0jKk+kAFtQ e7o5CoTEzbIVCCnaCte8tO2FjUxR3udsHz/BSpdwQSNLmOOAphd56X6mG+c6nzvYi2mfbG0vRlom5szajI mUPtduDOBMXSZtbsjoBjnInCDm0nI9RtFMw6u48dk+LbE3Q84k4PUiPo3CDsRRXNVmVqAVHRnJELa894np Y0MXW9vygbESBKSn4CdbeAm6j9V1pmP5ExJNMEZvtAkqZfe1uG6z3Ww1u3yzc3J2CgR2RAjs9BQfzTltPn MUN8wUiZPodVmcNjEpDdM1aMk3mY0ysfCJYjpiykq0mQM/UqVcHyT3WQ5wXEYHdZVkMwFyWUAZql6lNU7Z 0Ym8x3SAo0k9E0ONFNFu+2Zk+0wHZVJ1KEeezgeanECqBqUsi+QLTcqzVRElzEgi0STMVRGtixLPMJqEGy +mvF4aSz+agBwrLAE3zC6aBTYoo4May1magBotKw81ks10DfxVrSo9RTKeru1rVY/Sa1jlRU3AX5W85I2u 9tkzbXSltWaOs5GrXpc+R7SGHIOV63vgMymWiUyP4Gj5rzxriQsrLK2lyJcC1pL74E68WcN/DycIFDBdY+ aHCp7cWPP3XRh/FMxN2G9pQ611vHtDLX3iK/S+VeWbwo3ShJOqQGuWZZkz9GZMIrlrAl689AWdOXnaTAaN GANSCazzZxJYKXLKkVd5ZLcUV3mAXsoufXg4h7sa/4avDlSMGrAv8GgOOYqNI+tqOMnkGex4IWWgIJZJZN vRgbWMOZDUINV8OSkX7Da8HDFEZMp2RU95W6nzTKJnRa5Bg6JUGzsVtCx4QQInuFIXnBLBD4dWlDYcxanX RE7txzLX7qIXOzCCM+5ykM9lGZK0XyXALXe6Y+MZi7LnUjvrD8FXDrpGZOZuTttD41CmJjva1T7U9pJRxd PEJlEWLSxzKTOaMTX7WmaB4/xtnvb25fJqpT/4TRcwV7V2ep4fsBsVauDr3S/siqKN7oxzMT0kjwcYRWA0 4Juij++q21oRkel6lr1uKcnaZK2eX/CSJB0lK70AeVPBzOnuiNDKWkKRS9gbSWhpAS0//o2snw0Ledjcmr 2aWr7yjM+pwbV0gIeZNb52sbJXo+nVaPrBjKad374l5gXejcfXKqpZGIetbSUjIWEunwH9uw+pIFm0kPrA fPosxtMS+JLTo685Z+wi5z38XLq3yJvPG7uL1C3bX/g09Ka+wnqUm83kxYw06MT7MHRAV++REumRFYbKe/ m0jNMTe6MgJxnNHsDeK+D7HLZL+z6xR2gEHmN1jQ+Urr37u82CL5QYLJAZf35ukETJdacV5dbhExis2a8O bcNDypSUMn6AUOFkcThSMqVlrEKFjAXPE5dOWAIVzIIgpcHesxkIu92fPzzaMW2X2RlLkmfezlgOGa92xn IA/Q0D1YfHlbIISX44PxVtDr+X9pykgHZfXadX1ymQjM/wLMjhSQHTaJVHlOtJAyEnx6hf9lyH8v2Xohic 3eYaY+XSmiOSPY/vcJbpWrOqYuR0my5bNi7jJZUO0axe3t5qsqWqfJ96BnE9/BIuVmHJuHwPcqu+VfhK4W 58K+jtyXwrgF3Itzp79a1K+Vab8Hr+FHsDmc+qPomrRbTQOlcrVWGLrtY2xdQzPi60a1cqLhIruFLsjmm3 hCuVIr8cVyqPTJeuVB6gF+BKxS8qLm9NMxLXJ6YRIjZTRbuoU/QcUM4CbpAlMNYwCwrOgR5dnkTR08sPSj W7epO0SL7FQ45GkS7Vov/CcFcWhKT2zKrS2I1TwVPzf0TzAP9/Gg6GYaLITO2UfmI86/C675vg3Y/lO9Rp 1yVWHPdednd3Yem2BDcWlg2f/NoC3tAKn+ilzBeFoJXjsbcEJf43d+HaIFJGxhxZC/h6HLvSwJ4eFbx7Wk FghDIZrys5ZIuP/GdJ9ViFl3cPuozKphm+fw+uwP1nGqAkK3YMpPuQkTJ0Sd71yNPyqUHE3kqkGUUKZPis ve/xfKyBJBHMifNge/4b3sUtMqWfu+5Zty02O2Lx57ELKQqhise1pPjCXldGC5jp79Y1mRX85DM7Bm0hC8 plDdcYPdhk1X0DhDzLzVmgbEge680T7laJ4C7HEZ9l+Dm5+K6p2e7U8vCQl0uL8+qrk+jw01QTNvwMX5cN JwvHAWIgpBFgbCca+KhJcTo7qUkztajQ59hseZpV/mxRwD4TozKGBYbDDOYRg3eA7hjT0mnTJ1BpusgitJ 7WNI4qsvzlya/1qvOq67xY0FXT9Sw3YYei8qj9KippRWXem30bA/nBO8Y9gR34N+hTTxyHRc/3bgTIMQa/ ku5pt4hhHaRV8/aP', -- data2 'jrZ6cC0LdbEC6gNr0gAcOfB2R/gVqL50JbzY/Gbrg215hL/67lgTpC8cdPE/UEsHCKlUj/U2FwAAsrgAAF BLAQIUABQACAAIAPgVZTypVI/1NhcAALK4AAABAAAAAAAAAAAAAAAAAAAAAAB6UEsFBgAAAAABAAEALwAA AGUXAAAAAA==' ); UPDATE MGMT_PAF_TEXTUAL_DATA SET DATA_SIZE = 8178 WHERE DATA_GUID = l_data_guid; INSERT INTO MGMT_PAF_PROCEDURES ( PROCEDURE_GUID , BASE_GUID, VERSION, APPLICATION_NAME, NAME, DESCRIPTION, LAST_UPDATED, CREATED_BY, IS_ORACLE, HELPSET, DATA_GUID ) VALUES ( l_guid, l_guid, '1.0', 'DBRACPROV', 'PROCEDURE_NAME_DBEC', 'PROCEDURE_DESC_DBEC', to_timestamp('2010-03-05 02:47:49.838', 'yyyy-mm-dd hh24:mi:ss.ff'), 'ORACLE CORPORATION', 'Y', 'paf_extend_cluster_introduction', l_data_guid ); COMMIT; END; END; /