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 := '5C83CA67B606A008E040578C060B1CC2'; 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) VALUES( l_data_guid, 0, 'Base64', -- data0 'UEsDBBQACAAIAPcVZTwAAAAAAAAAAAAAAAABAAAAer1ae3PiOBL/P59C580eoSoDJJk8ZjLJngEn4ZYAh0 n2purqXMIW4F3bciQbhsown/1aMjbGMQ+n9jZUBVtSt/rxUz+UfPnlm+ugKWHcph66QaWTSq2EiGdSy/bG YuBpcPfhqvTL7RefUZNYISPx8hvlrFJTkMkIDohVn98o3b7aaGsKIoxR9kgtcqPwgPoKCuY+PPdwYE66DJ sOadZ1OgpmmBEFjUPbulHOG1dnDfXisn5Ru1BrtSut9rF2fnnVqF3U6ieNxqmCHMyDJ98Sm90oJ6cXl5dX sPbi48m5gizCTWb7gRSrpzeNgaYPjKamN/oK8rArdlcHjQdDH6idptrudjQjktZo1hUERvD4jTIJAv9ztT qbzSpUilkxqVv18agKyk9toTRYRbXgkbJ/P7aV2y8Tgi3CllvAyoqPXeXWH7LQ+1KNJjOLeIDHgguYTbn9 mbiWwSgNfq5qjzrMkA1UgjUPLarcit+bWJMg9A3iTZXbA3eODkHlB13rCTd+Ll0j+fMTAjdMECc+ZjigDE 0xq6CQEwsNiUNnlYOfkM011w/mR393guuA8OC2DIN9YM48jgIWEmSPgM6Bh2QJECEiqASDnkMwJ8iiyKMB cgFMozkKJrCEh0NGw8D2SOUAnpOtDsvo4PVACAiCHx0KlmWQ+x/GdSQ0D5gAZECROSHmH3KlXCWUKwl5jv 5mkRHwtaLx8vVBRPmb7Vl0xhEjL6HNCEcY5AqHDvnwElLAUsx6BLbwMefi2QsdBwkDuSQAsEtOTOq/lA2R F6QoZfT9e3rgP/DJDpZKIMkCbIItq90UHpFm7Wi/GdGrNK5qWWAfsBhIaIJX5ggHcmBIACwCdYiOULtptF v1vtr/agjKYpZe7X9YTpvaIzPDsXwAxdLg8dRhZjuYPdQ6z6+lzHhpEZEIHyTuzKwpl+WSaFvpu03M0xwX 8jdxONlJ/QPxH0f//X74usT8onz4utJscbSa+H5Y/rF6+zG+3sk1TZs8ApeYNhJzg21AMWVNlBSL18zqhS KgsvIquAxhby5PLEdzGqKZzSfiEIgZ+BIIyQoN5Jo3tRn1XOIF6BkzGwPaEQZITOjMi4/5Cg9KJLr22Ox3 u4PSourYQwVQu33F2alYc7AKRRYxHRFTIEry2y8BZmMStG04BVH0n1AeKMj24EBNbTK7UaIQa0BAx0PQVm YSC0S2sTNIUayF9sH9ALSF0H7X7RsPXX2gx+FdLK4TOCgyyxALYvN0qfpmad7u6JLtOz5qqR1dsnnH+BGB UTiPKH7HU1xxsDeu6DLmxJzAEg9i52oxsoFUqquLt6K0jPgOhnwuc07TZlvpIYo4lWcZmGJ624M85pmEFy XEjmMkxMZkl9o5HKyh3mry4lTC+8SDcF7YVqHXhxStS1AI4mrKz9UVtLZMFNmOv9MlvoDhOywj6XRmvo+w Ccf3XYR9IoNcYW/YXJ43qHWKUvIXZ+XDggDQ/9UuShXYLtQA2PXfTdimY5gR5KPQM0U8SpMvS1Q+5y72Kt YQSs+KrjbrPUZ6olbnPIV+uhoVOxVgKa3d8kb0ngQQu2OOAG05A9zEZFEhuw/5YqbH9xbU96Wgah1C2h9Q 86zYJSPi1K4nKAgGPnxBhe+HAdHhDZFvPhP7irh/+Jqx2ZEgqIhmpbyIm5Y79dM5tCrnH08/qbXTZkOrnc mm5dNF7dPp+clpJpe0Oq2B0eg+9qAN0Xrr7cn6nJBX1J+OQ5zeRNQCUTThUjA4cpVsvsuTqZ4vE7HsQGDx Rhlhh2cTXrdjDB5ausyu6yKmZ5TEgIw6jhAjK2X0WMlmyTw5G3vYbrX5o7ZJrEdN2cuvGZAd5Tq0uY9QD0 avr21yaXZWOPV3OpQiwXczzQn60nvNkD2qphv/7NZjVrAwqk1kpo6MyGEhuNETTgShRUeWo4CWr4AfMp/y OM/IgBExTQMjYmntJWGk7JtpcMUQWi/ZTqXObJTyo+4xBZNlCbQQNlonS9LaikYegHh8E4nMaHk0YmITkc xmeURiIocoydVvFMoWWJK4unQ/FMuy0bOnEUCTN8EATPEZODz1O3eMuqL2Pyo14wW8Gl2goNRIHIerDeq6 1KuqjlO9F5WObVb7oWdAl2AA4KEB5kazXhJoJ9+ICaejudp36XHagKzsPfkbUXWXjyqTglmC5QkTGkA7er Q04CpjL8TeCQCx7zvzNQCuAa7R7dy1W42BoXbU9lcdTvga4N5MvwFcol2lo0LQaLhWG7phaIj48nrnoSAU tzCUQGhTU2aXPdGwN3NoUdi8R6F3SjgvEyCV4KyA9UeObQaFuPqx1fc+V1uY2byPzYRVlFcKqSiuDFujO2 w7CReJQJm404dle2iPE/4qWx+Da1gQjx8nLkmakMVxphM9vjiuiU9eWlBre6QFiIX9gVFvq41fu0+QRFt9 rTFoPWtvImbuKqHynxkellGhWV8LDD42rKEhTOmQgBQLCoxIm6pjAGY8xkPuE88aQO0KZr5RLms7M5R6si NDvQ0QWzNUdOebb+z1ueKhonDa2sIR7M5ty3BsHrzlCB5xsU58vfARdJb97QbG0E8A2zb3WEG+MiAYtvUn RQoZKQ1r75y5P+MXx4jQkBU0afyKMQz9McMWMVxqrVz/YTlaiNOygcyIFY0WkwnLVsiQJyPhF70VYbPqTT MyJRNFw7/hx115hmMq+xeHHVAZLLooyEVffImwyMsTf1UQncLzqFgE3RUZT3d1bjnh71nrt+6+bgqA2Vnl PWhZXkhswkw0XczNe4fX/6d3d1XQ4i90BuSkIDK3MaIswTsvmDtDT4X+WP4tbycMzvYotuPYmb6kXOyASv +pY4ibfMBHqxddbcvOTdcGmSp720rlr3Bz4WKP+kmtl1/Bfdyrguv29ijgchdJLZa3ENX07cjm7l/etYiG pnUPX+127gVAA4p8exxGF1gN4EvMqNnYhaLz91wDbRMpUj9vxRtIcA/7fEIDoULieHF3ZZhpdXI66yXhrz CaEJohY1BzrrfSia3XLszS4/F/Ltz+D1BLBwjzO6BO3AgAAO8gAABQSwECFAAUAAgACAD3FWU88zugTtwI AADvIAAAAQAAAAAAAAAAAAAAAAAAAAAAelBLBQYAAAAAAQABAC8AAAALCQAAAAA=' ); UPDATE MGMT_PAF_TEXTUAL_DATA SET DATA_SIZE = 3218 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, DATA_GUID ) VALUES ( l_guid, l_guid, '3.0', 'PatchOracleDBSoftware', 'PATCH_STANDALONE_ORACLE_DB', 'PSD_TEST_DESCR', to_timestamp('2010-03-05 02:47:46.415', 'yyyy-mm-dd hh24:mi:ss.ff'), 'ORACLE', 'Y', l_data_guid ); COMMIT; END; END; /