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 := '22CA370FAABB9A91E04057886F77764F'; 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) VALUES( l_data_guid, 0, 'Base64', -- data0 'UEsDBBQACAAIAEo9Ez8AAAAAAAAAAAAAAAABAAAAeu1dbXObuBb+K1zv3Ul3Jms7TuwkO012MOCEWcfmAk 63+4WhNmnYccAXcNPunfz3e8SbeREOCJw4rT6kTZB0JB3pHD1HehDvf//6sGS+GI5r2hZzwRwctbsHjGHN 7YVpfUYPZuro17OD3y/frxx7bizWjhFlv2idtLstZu4Yumcsht8uWlOZ5cYCw01lCX5VxemkxRiOYzs39s K4aLmevWox3rcV/A45JXl622I+r83FRavX49jj0+6IZYfDc/b8SOiedPunZ2eD0enp6eBk1GKWuuvNVgtU 1UXr6PjoGB6fH5+fdc9azMJw54658vxGgVhO4GeyoPGCwrUYS38wkk8n7I2gfRChadB1y71o3Xve6rdO5/ HxsW07+nxptOf2Q2el33Wgy19M1FXQBbuAX23nz5tx6/L9vaEvDCcU7a5XK9uBdklL3buznYfW5flR77B3 fPy+E2TMFADR7ZUO2VafnLVVlCkUxpuOMfdsxzTc1uWjaS3sR/e4dxj+NjgpKK5/NizvNhgovz0/HXXbvX a3DQOMmpb4s0CC6+mfUb9heFuXPxsPC82xbe/njnCjQIpRUGqxiivtFYpeGHf6egnNgz44rcsbc+7Yrn3n MZztgCp1NJBFaoFZeG0sV67hgf70O23uajBomml5jr1Yz7cUjccpbKFbUPNP/Xb3X/32Efz0Dp/NsWWM3f XCbl2ifwuVpYIx+MPKS5s8C2O+1IOa3Mv3nu58Nryx6Xqh6dzbrueb3QKG2NSXauJpyhL8MvYdo/oS3MgU UE53ZDuiBUO8XMJ0/qI7pv5pabibXxlogusGBf7Wv+jtpW59biueA1MiEhSYu3Y9BYMasoqgjadcq1NNBj eeKaogf2DBMpVrUfKFjcSxUFUQP6xXPmyIluwUchUE7agrghMmqsyONXFyC79N5Y9IsYE7rShJgdLslaCp HyVBu+WVP7RbdjwTaomZcjKZlMmUF8aiopKVlmZDrUEJ7FhkFTI5SAESK6siGhEyEf5Q1JQhTmC6jlhOQI LYGzIhSfNLTlsCS85M/Lq+QEUTDhmyQuIJyEuLEyg8HmszRZBJfQiJ0YPueFZlSfQmyeJtXdtAIkRJI5dw K8rqDJxWvXZEUmo1BRnojSjL02bsNBR11KSwXl1haJKLPEEpND5kRSVWUT5M5eolhVuRq26I3PRGGgsqwP ihFhpl5YkwHM0UWDkFXiNtPCcrEEdI4+lHf/WrWhwcYp3irHJTp7gyncmcQFQU9RuNwHQCEISk18SFUZ+J C28WxRFYGTdWuNEVkS+8noL3IfHjm9KiRNL1mmtoVgRJF5SxprLDccaNdxJRQmcTlOwgQNHdh2sao9AYhc YoNEahMQqNUWiMQmMUGqPQGIXGKDRG2ZcYxdHnNEahMQqNUWiMQmMUGqPQGIXGKDRGoTEKjVFojLI3MUpE 9OIcl8YoNEahMQqNUWiMQmMUGqPQGIXGKDRGoTEKjVEailFMyzOcL6bxeNGybMsoFbSo96bLoHCF8e4N5s 50QCbKxkygYVHz/MfooMV/SBy9NADUiZ1wzUHeHyzcKH4k9dE1oBMNtfY3wPkRYFwjWyj1gVKdwKWpjZNG 4llCrFkn6GsAZO7Jul8T6+45bNDdhxFFDhQ5UORAkQNFDhQ5UORAkUM55ODoc4ocKHKgyIEiB4ocKHKgyO F7Qw4lgIIsjDT1Sk3dH4eeoZMecjyAxr6a1lwDGutdtDxnHeOT5BQo7Hql87uwY0QjGhdupnOxONKJjlgg mvAnuAwembkKFj/RYNo1IgdmfyNywJQqT31BUdAaoCokthseDSPzIzX/UAQ67K0pAjkSUhEwJf7QeFEuV3 Zo20tDt2IfrGgKewvIZ6opH8YiQGthLHDgVkkk+Ufm4+lEIC1ceiHNF/dP3EnrRoVr1O0f2JPWjQrXrLv8 mGHIFSIAK0WVxckVcXG09pAUlgmmmTybaJIsyMJ/FJKVtuaCjyZKcyJIsWezyIW4FTzvY3AI5HzsqBDCcF R/ZbfJyazKXRPHjX6Mh0KKSIBCsMjDJJxwAjlOEJAFSFPFxwlk2DFiCWnSmFVHU/mGXAIrz0S+FkmKGP5u JCBwKYsSyZCmBZFOjCQcIBYwFCdsjU0NJEKSp/yMA0QvyAqBiBT/jAzEpiTUGJe0IFKdJDEWsYCa44JE1B yXFLWPaFzSEmqMS1oQqU6SwJVYQM1xQSIw43K3tvyLr5MiwqvM3W/ug261V6s2/I3uM2+LlomiX/Mfg5ci uWbyWVWBi1V7tlra+kK1FfvOe9QdY2x+cnTnWyR+XZCMYtj0ZdeuZ6zgv7n9sFp7hgJ/McbXlWO4wYXz// 5fsqXvfnmK7o8fsef97pnQPzk5Pu/2eE7oHqP747nzQfe81z/qZSJ8NBtmqgBoVISZJaUi/WxaNHVX0Mrl 0lhK97prMEG47aImLXRPb2cu1cY1jC3RMOkaQRTUnBD6xXG/n3DNy9HzlK5sy7A8X1vxX6hlMGS/QStn8m Tk2A+S7t2/Cx7ObWuue+8OuCi325n6w8sknkiO4Rj/XZuu6Rm/3plf1wnpbufgkAm7Ht1U/3TIHKQLjdKF Dn55QiO28G+0N78YBU084KMMcasST8A1MVLiXv7O5iL7sHImqNb4aszXSKsHqNLgL4Pf1B1sPCxsDmHu2S p6kBu2IX7YQIUL0wtnpa+HBF5/ygwrilkxg4oep4b0k2n5310Ik6PGtv1vFnAPi7FpGbe647ax+7rMF325 NuL2ZJHjE5rFpWtIbVluJAfzPpVaTe62E51cNVsyV6uVvUKuH5WNK9l80qCSJMzZWK7Z+TzVWos5wcvVkc 9TUSOYyCpXCSaTX0sn5XTg79AXdVJO8jmfGW33IfO00BK4KDRCrqwRJvdmnrDOFSX/JaZ9fjrF9/ixf43d le9fd+q8QF3ggZegWOYvc3VnLo2avovHq80ApSF9x4KyvgockoRsLlZlTmPFuULtlZ6IuD3SrCsr2tetNu VT24ebGhILYuYPv+5kqad40UvvyMK6hha/ueOiAavSpnBXFGOCQTX5rVsi+Whgdthr9OPP2/Y/5qqqCoKp 458IRc0Lt+w7KdvbBgsLEOa7jafJbmE8HR4gzHZwGDu76AzjafMoOoeAzNAklNcXl9/OgAwKOP3A4lFWLD QVKngx/F71UwGQhVUysE9tJo2nLO+XnI5Uf+UEATJEHVmA65fZkr1D6tdLYOFRZSwsxW8KYyFxIjn23H/b n/ypAv/zScHWerlsoafBCaDEjkbgalVHt9w7w8m39qTbxOoTY0BuKn30s7Eydy3eClk0mEvP2pJrr525oS 3CL0N9e1FfBkYHdRoa2CLEgQsMnOpAgc7aAk/A/GrnBYBSPC2YMprlM6+yqAM9xdSsO/N7cAUaWhdTBcME 5HvypUJl4StMwZDAkAsloGq1pYlOi7fB1NTFFFt68Yz+fO05eO2Zlh8uPz8B8GEAGl2Yl7o3v8eOcNDfmW s4W7UVu8siCZLuuo+2syiUEHtXfDcxLSgXfaDCmMoTbj5ddSd0FM1iPYikH2wrBfeYmWcuwWNAKgJ+HXCO WhQ9ux3/s2oMG8yPesDv5KhRjxVcsbDFZeUzVIl2BEXdBk7IZvEziNNHqbUM+UWizeRb3fnWpvk01dqYCO uqx904YFZlDyrRgXhjtoG9oVc1uV5FkwudWLHRCepMSiOe2NwSSS9jaEhP6DuLK2prL25rJfdaHHu5hNbg IXnqPXoMID85rgbIbwVZHH2EcYNW88GcyoLyfJYX31K5NRzz7huj3ENEuGDG9jw4Zqhp6CeEmyrbFRfZNk 5tVTdX/c1H5Zl9yQQrv/Jsjracw2/8NrnvHDFs8xueQcJreYdG18vYhpNGW9eE+9VMmLudabLA8h/zpgtJ r2as3HINFTtoE6em', -- data1 'nQ7q2KmE9jVBDfmTmlA7pSfODRhcPGOkYLuU5MRkt0bNDzOH240fOCRt5JmqGjv22a2reta5lDT7crtpm1 s8ccZ/Ws34QyiDpmLO+hNpL+4EeGO1tJt0Amd1nEC0z5BQU+QIkkl7dW5b+LpMkZXlclY0ghw3MtOdXIaK /Sl+gy7fo8K8FQ9NCt61y1VYkLFGbZtX8rZXFuerVtdzJ9d1Tq1xr/XlKsBkqlYL9s2/XDW4XFX5D7jXxT BbkZhsZBa73UqrW+aW9xuxw4LPSzA6hW9C4oepKDt5zb1qNffq1dxsxJJ9Sa7ZnQjMO3R5P5PLU70He8Ts KQRhDZ9pnpxXg2B+d2XhKg/A4pQXh1+y8dlEwCsJwJhr+6EuCmProDDQBA6BRY/3nntW0b+Xna/1NguG1T cLJPT6K26vIEh5+xsGXK0NA3SiidsxiJ4Tbxn4AuieAd0zqL5nsGW14is6gLHATvD7BZukF3cBvkUz6xUT HeQZek0fINTxAb4mZhJutUomVTGAKcQXE1VBBC1ZuJnePneQtvkYwlNz4Kc8UfdkVOEUNH6ZGE/URcl4om 6U8t0QdfvdmkTdWJVbibrpXC9G1IVq94yoq7sPuyHqJl8S2zuiLvQa/TRJ1A3vstgnoi40qSxRlx9iebr9 ox+Dpwtz4fpZoNDvkVF1oy/zFLN14xyNE3b7x02sQgEPF/1T7F2L8mB964vwdotcG+XtbupN+EBK0KUE3V dgC/ZPmvBQyCMEiH87/sPlqYr+9oil618EtPeMwcz3nBpkDBa+ldkMKzd1XcIbZ+X2+yXsDPUIPP27tMXF UO4w/Tzi7f7yDHPXl1HM3t0kv1kGL7XDXb4dXQ6dD4h4PyhsK+L9oLTX4v3w0PFPoIyaRn9acXFNRG3ViE EJPWaJQYEa94gYlLyDLCM4kUQs0/8IHz/MsX/yt6/tGb/oRU+rn2dl4S7afdq/s5/UEVXjvnbLOU9Z8EN0 bJr9bhDO455V9LhDAFOTEcbdhgmEF/lsv7tnq68NnSzkt+7Mz5tiB7u9nUdeW0y2bs+2lzXfx+ifNwLxIk vPX3buI71y60I4puJVdlXYJDR6vlpkDN/7orDdaft1YLLUuoRnV946/MYH7ugcnj+R302U/OpGnUUgdg/t xBc0MM3dslm0fbLE39bIsxI3ia8VWsAw4A48ytNIM/cWZ2ZpDoBWvcIpeakxxsoSyYSy/RuPiySjxOpy5b wewsfbw6cqDIhy0RNLQoJA/gzPgXiV0KlxDkR/uOvwKSJDYMKnZFLDPIl4x+UV+RH9KheZxRe94/kRKBnP j4hSvh9+RN2LzGJVbuVHpHO9GD8Cqt0zfgSM9274EcnLjfeOHwG9Rj9N8iPCb4bsEz8CmlSXH/GD3GMGOi iBIUZvjx8x6DaxCm24D8XetSjP6/Ejilwb5UfE5ZM+kPIjKD/iFc5tB0dNeKgN92E7/sPlecP8CLRw7P2x LNL2bo5lC146aYgdkfrIxxtnRwx6Fa2s3J1lWWiTJj4kYM0b5T1Q+9od66EU5h4cE7EecBt3m6S3zXkYnD Rx0clGQ1k6g6+gH57NgPmiHWUzbDsfwxyi7SGZoRzzoO7LrHjKBM5Pv8gr4IN+o6+Ay8Jr+NCm3wEfDHby DjhSTiMvgfsX0PHDkEtA3winb4SXuzwSjOo5YtPglBKb9orYNDgrEZ1toS3tK2mprgt4o9BvbzhLtTEZpR ntgmbUGAssS1kKzyB3SVlqhLJTLvSveMuWLFyJPu5RWflKUBXtg6hea/7A5VeubZlf7y6uxadIVcwHcVJz Tal7E9dzykzczrVFlfv1JcQmrRh5u0JTjhIbpB6VM5phszy314j0Gqe5DbgmrvrJ75glUhomsEU75wT8tc 1zx54bi7VjXP4fUEsHCGoEKjgGEQAA+9cAAFBLAQIUABQACAAIAEo9Ez9qBCo4BhEAAPvXAAABAAAAAAAA AAAAAAAAAAAAAAB6UEsFBgAAAAABAAEALwAAADURAAAAAA==' ); UPDATE MGMT_PAF_TEXTUAL_DATA SET DATA_SIZE = 6040 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, '4.0', 'RACPROV', 'PROCEDURE_NAME_WIN', 'PROCEDURE_DESC', to_timestamp('2011-08-19 07:42:19.808', 'yyyy-mm-dd hh24:mi:ss.ff'), 'ORACLE CORPORATION', 'Y', 'paf_cs_rac_introduction', l_data_guid ); COMMIT; END; END; /