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 := '0089B89CABB78777AE79A56C676552CF'; 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 'UEsDBBQACAAIAEU9Ez8AAAAAAAAAAAAAAAABAAAAeu1d63ObSLb/nr+CItmyU2Xr5Xcm9l4EKGYjCxYkT3 K/sFi0I2YQsIBs5075f7+nm4cAgSwejp2MUokj0acP3ad/59GnH/74z4e5Sd0h1zNsizqndrqtzg6FrKmt G9Y3/GAyHuyf7vzz4qPj2lOkL1wUkZ/Th60OTU1dpPlI738/p0WZYYc8xYqyBB/HgjiiKeS6tntl6+ic9n zboSn/uwOfgVKSxWua+rYw9HO60zk965+esUy/f3J6cnLC8CdnzNExe3xyfHTUYwc0ZWqeP3F0/KpzunvQ PTg5Pjw76B71DmhKR97UNRyfNArYsjw3kXmV4xVW5aANljZHyYIRc8WTAui85Z3TM993PrTb9/f3LdvVpi ZqTe1529Fu29DpOwN3FqTB6PDRdr9cDemLjzOk6cgNOXsLx7FdaJlkav6t7c7pi8PjvW63s9frHu71DvaO zuBTb+8M/vU6px/bQe0MFzS/DgRLX3Q7rV6r0zoooPQWN2OQIn2hIxP5SLVAvAWk0ImWo0GDnBt3YRURhc 3mDBdNfds1kEdfmIa1eDjo7ZH/jw+D/1XD1yxjMd/zbFNzDQ+ezxz4oRmY5N6wdPveg0rhp+PDoh742jcs UsAOffEPNNdV17b9f7T5KwVKijqjo1ttYfrXCJi79IWMdOpS8wuIb+/1iQxDpVttjohpVCwlD/kLR0XWHX 3xhqKot28peEKx9nwOWgGPDde25sjyqTvotHZjIg+TYSIo3KWHnDoU+jIjf1UlZnypKqMrkd6j3/Gj6792 +CtOFsXxzmPbNG4Oeh9ynq48c5Br5hZYyL+33T9zy/7Q/2z/4SJc1jYOTo/bU9OANj9JR7//LdUbiZeHR9 CfnB4UtisqABXaX0+EHvy2JCrCl/ziiSzkF1yOr4aqpLkecosJ9gOC3LffGNbKM++7N9estqbPDasd2BCv PUL+PjdS9jutw1MipM2qASWMzn631T1rF8qnfdQ6bR0UF3sGqDP5tinhRo3b+IVt4/j0eJ+o+r4/A+3U9+ egcUYeRtS+MCrCCAg7W+VfYHgvxSs+p0qIyGyNjFo9u0atvF/ol3pv4TtyeBcwzgMplk7e86SgCW8wWwqY rciaU56DpsatMS2wYKQO/jP/Tr2zPXD2/1lgc0jte//5LVUIDj9R6mZKZ5qr32suOo8I5gmC6cyeO9Qu8I 9aif8Yt9QueSf6L0UrC0tUaOo99Vdcvh4F7YVHVLxt3juRXNOcoyYR/sbpsTNd5V8OaXWN6wZvLXIbTb36 kUKmhxqTgudo7nSTthDChuVQ7+WPb1IySaHxUtqffFlFC6GhY2DRAbK048OSwKLWdktgjg9HbfBgdzlebo WwvEyf8+3rhDrEDiVPUiXFWlmwmOUmPSOvzhFrPcHWe3sszqycvIOzzgNdUk6FDQVPAgqleZ4x/bCGpop0 mn9noUwcZ4pl+LeVCWqo5034uRfzdOuNESN8WRNtFMZ8NcZntQ2iMug2GZJopjPTnmxWTNmwN67x9lXRcJ p7D+JLCWcF2m+piRVnXSgRQmHNxwkr5bvno/mbNAzevIHIeLCwpjhBRPk2mdznxsQtTCm56NZ4oPwZggJz gSgH+gVvgYq2a3wzLM0MCjCxYTkL36P28efue4rP4UpyDLi89566JvW8xU0o7qBLEEXvvovI9yDexlTvIe T+H/W3sPydpPkzBTnwkP5Ak6dYajo01YK2EZnHLB4TssuUQP2APdVa8mxlqQj/rNCLOAXEbx7fvFmTg/IW uk1f4J9FRK49vUSmA3KhL6CGOvXUML01NRcwqi5Jc6mG5btFPHQnzqD1Wp3C5FkIm5DWixNJb3utw1avu6 csFD78/AEmJ9SVMXVtjyDLewvT5CVjHQHoMfSAzcVHX3O/IX9oeH6Y5JzZnk8DRKDxdwa6P6ct20IkY6oD QAzNHCfIUknM8czwKPiLQQhwRC6ypgAkEECUzdS+AYuB4Xr+JVQfwTP64mMM5OVHiqhlUOcP7U5rmZr1ra X4LqhLxOt3Uf6scoKsDkWWbperO1F4GedTy9YT+4OJwjJjngMzoyjQBK4sC5lhVWGkjJkRW/r1HH8tsLxS thp53XCo4l7juu2ExNvL8X8JLGAYeAPbDZKdWzD8rcEgo7lm4EULggrBYmVli4i/KyKmrrd1FFskBEjYuo ktFEIobJ3EFg8xHvSbrY/YAoEAYesitkgIkLD1EFs4xHC43fqHXx8GhIl9Swbeo+5nxnRG3RumSd0gKkjH 6lHzZj+xm8iO5kuJ1iUGFr4Z/oyoHhvkuintFv8kEseLFnawwmFbUQfcn90y/7QjEFCSLBt5p7cyJAwuqz smSbkWyqYMQ2nSV0cixw8FZaxis4K/lLZJ7HCijHn5d0bm1WC7N9nUVwU5+P0qac1AlFVoGE92jJfkcikC g9pcZP6KEUbC6JMat6osC4mRxwIzrNwERrlSJZlX+NG4SlVxpHL9YINlydr9IcN+VsXJWP00EUr7RY4ZM3 1G4WNlriS8sOlK/cpqPJSlpQg6UasdoW6k9KJStCIzWKpVdEpkZZUAESNQvWaGk9Jvv+aUz3V5SLJwvTQ2 1VkIklqdw7UgjyfMsGY7Ii61moKH5UqQZbGZ0QlZdZtk1qvLTFBUkR0oKnvJs58VUMN/TwSZ56qy6TXACN vFmlzAIChClVo1nWOGQxUzUnHWMRLYqlFBpWYS51VPWFkWVZoxEKA2/wV6Av5fYsbQnZGKI7gm+EDbGuED Hd2cj4cgPPXPad9doCWsys9/8/hAQzZn1LdtE2lWUjE/QZSjjkW1D32bKJfl9TLggOvG9r0Gi+UEqAIfmR +QNlRBncIrCra4Y6UK7qUhM4ao96psPdxLfpSOVCoYqDEjf+JLi0v5qnB9Jk5qlIXOSByrvwsjTvxdqVI9 UfU22hGYqBoe/wzOULUcp6VbLd1pLQ8QCpaBp5jG/yEOOabk2tOIOUz9fE6qzHhoa3o49eQ0X4u4mpnHVd n3TW36p7jw49yuTZ7Y8KQqSybYaDK1rVsjHt0FOaI7jueoZPqa3iYHfXHgv6k9dxY+UuAbhR4cF3nBoeJ3 fwWS3H3/SFPIwoOrR8YnOCw8YM6OOqf80WHvjOn0OJbvHHSOTk7Zs+POWe+o28vM+lnxSpqMw+PAMDPAsz Thf8PjyaH/CknIweAMCXTAgcabJjKlmeYhKpiAe7il0FetlcqLPuY0sr9BI6VLPIda08SAIK+BsUR1cnzX uAtkGn/DDYXB/ACNnsijgWvP8b7P3R0uIvDaIhlrKvEEDAMlJQ4/t8Mjyd1Wpw2yUKNDZl6bnaHpn1HWhB y6UnBiZoq8HTKCD2gKw8wtWxMMpW6zWDUnTuHYsvliQ7rhY1BE9RIHzAGKvmER7knZgrGTAtFe87Iw+Kom kxh41gem6FqJ7ROmJnJeS33x8cawyCH50B5GHWyRuuxcHxoWutZcr5Wc2Qc7h2PsJIoeMdI25gmRyUrUlO G9JlXzGKhlEi/wPYRROwX3suh/SmO5csqg8OOJpCrKZVoPLjk5UZSyKbYFZoloQPytQAOChwCaqebv7rAR dawOiSfr1GFnj9qBVij4DPnynQB+DP/n00JyUB5vVnfRfxcGPsdLaZZODYwHaAabaEYdHeQ3GC0cNyljiK bwWJBRi2OEVAmJj0pAPJWVXmI7MWbv/grQmCJ93KNCaKaDKzwcZTQstfqyfH34xig9W45nEHKScCviuLz8 oBQnLNBAAcTR8GvMbSwHE/d2ShN+nGtYWMZDO9AEaGFN8A3ywQeDDy4gjBXIQKfDwscqPoJANTIoqyCOS8 qCOJ4Zk2R7xkLnp+R/JZgm/Q7JEr+MLuet/67IKoeolJ90bdOE1lQLEpnOBmDH4rJsLKsAPpkVh8DhFEaV Y1lUJJ4tDCqT5T88', -- data1 'poxW3QR8vAdfXIA7UM9+MN3NAsiCWDFXYMvgMCuvHxm5bfwuSRYlXh5/VUk2aY3u1VBEiH7aU9fD/wTr1m 45Ll4q9Y0g/i/TWrwk/IRkVhOrJS1bTrIxJyQvFS4n9X7dtDYzld9kfsv0nsMqpCbEQ5HhoimOipedcufE q1S1p8XMQbmZAOkPjKY4GgifcgxYuvyFJ8VBloTC43yDhSNYnq9ZU1TToh3WsmihhOJdFys2LUtQNgzBq7 8kQMpqbe4acTnNDVdmsTqGeZFmLQNWm+XafTZQy+rUS8/VXwbVMprbd4gCC1kTx0ebRvap/MimOFfGokTW /gayeEXWcFaQvkpSYjzJFpE8nOfvaPmbgkXxbWdpAHEuGFnIrQmc41oGkIx6vPjxBDpW6X5hiFTL/aV3gO b5+JNKPj7ahVPs5WOKF/bzwY2k1NCeaiY4+Ttk+bb7nYJCCjPh+tSlPa+bCWdOa6F+IoH/xb73GqyoKH9d xfsKRbN+ebmjqhzOyda+jBKFcxOLxJSvxtZxaN/AEZ5pNjnsZ+WD/0wm7P1j2eAwq3orwWFC87YYaQAjFP 9QDibuwmI8fI2JbudghmksZ7rFSTMLYitD1N90iFZnHYWOM7Tg8VaYVceZpXgdjhPvIzDxrvyGPSbbhMfM SnPFYSaE+TwYX25mfq1ofzoE5Db0Ypql7+bM+nDiMePk0tvdH9+vzXuH5gjXeSKmXJK8yqCypkbwrziGfN bZ0lMKV5TvbVTZNmbGf+FZ9Qq6HTMbiaNgPQ4v9JJeDF9lUNOE2R40kd9cUfWV2CSp6a8HR5m9oBn2mXWX 5ix49nagHBve75SbxoMMmNFEiha9VwxuuvyFrW2Y1GTJNsZFsEuxHoz79RYec6W3xHBWeNu05XPAgWxwdR yvwblZv1cLFhAKitdBzKmsyV0myBhJUrbZy3WG7/Kp6LVfbZGyyPClil/HEmVy4y4GfZOAb2S58inA55P9 pIB80hMfPV/yICHd1bxBINPXMC1KALZJrB43MT/KBWhKglsbXBryJ8+8My70mCIr58A/Ufg64lRoSZOwP2 0iJkmIbiUQCST3i0YHZ9XmRYo4GOPmr5kaxSQvfboHgwkfKKhqdVdkxrza1OxrN7m/4KKY5KLgxCClkNEm 6wDJkJRDYX6pJur6tVBHsnKSzAfgWgVdprzC+YAfBY0SxwV+xQxjn605JQnllzcNiYoazCk2Nuy1c4svm5 tLGISG1kP63HMvlIfxD7b7a5ZNcql+jaQxv13nzpu0xmveNQE8+GmXuBuzaoUBW851bj8W/GznGcC/eh49 B/85RK/ugoBLpJn+rB7+2XqLLMWyXHf+/7We88q7vvBHq8STs2W2V222HIXI+AzbutXENN2ryq5TA8NETa 4lsQdN5G1yJbsam2Tk+nzmuRHdSp9Ufi2TGIIGUWaH4S+zaxILh43k8KBt0VAXJ/OSRFskVJrR7MtI0yl8 jxSMTpMwOKoJA/jLcORyoTHTz4NAmmA7/JvfiCGEGQz2evJvTlA+NznsVRau8KnuSPnVqFHJCy/w/Tqpsp Jjkro7ouloZ+2lEiMRX19ail9qu11g6cpERsUnvpeXrO3iui08dnsUQMH1o4L4XH3+PdaPexTeYbtHdfeo zgYHxtmTsheiKWN88JXcAS1OxrmHvzMkT578zvl1lHnh4Gm5cDDYBCnzhQfAMwS/4CZe9qyJOX8gpydn/h myWua+mQ27Fe+geeb9uYGcFJ5oyOhzdIPoKwk3FhYF9bH/kUFwLW/WpOupt5QnT0bYD+C0uYp/VXhOyJGl qHSH0VNAqm/ns5debnK1B9sva6mD61aDUJwZ5lrqDEm7tHPyfNuJXdNGDoct73BE6Sl/k6TYzN3k/KaqPJ /DPUNaDuIjFkIGuXjXX5rgpTMThje175BL8tA1l9NYvvk7OvPFmVhoy0rzp56GVEu3lYH8YLsM8zzRGNf5 +Xay1Eb6TxucJW+J31QJl89de4r0hYsu/h9QSwcIgq6VylMRAAAxlwAAUEsBAhQAFAAIAAgART0TP4Kulc pTEQAAMZcAAAEAAAAAAAAAAAAAAAAAAAAAAHpQSwUGAAAAAAEAAQAvAAAAghEAAAAA' ); UPDATE MGMT_PAF_TEXTUAL_DATA SET DATA_SIZE = 6141 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_DN', 'PROCEDURE_DESC_DN', to_timestamp('2011-08-19 07:42:11.523', 'yyyy-mm-dd hh24:mi:ss.ff'), 'ORACLE CORPORATION', 'Y', 'paf_cs_delete_cluster_node_intro', l_data_guid ); COMMIT; END; END; /