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 := '2EECED3592A0175FE040578CE808291F'; 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 'UEsDBBQACAAIAEo9Ez8AAAAAAAAAAAAAAAABAAAAeu09a3ObyLLf8ytmSbZs17HRy8/E9l6MUKyzeh2QnO TUreJgGFtsELCA/Ngt//fbMzwEAiSBJDtn76Y2kTTT09PT06/padjzX54mBnrAjqtbJrpAOzW2uoOwqVqa bt6ThtGwdXC688vlue1YKtamDg7BL5hDtsog1cGKh7Wr5wumL3J8R2AQdhzL6VoavmBcz7IZ5D3b8F1qN6 8YdD/VtQumLgi80GwcndW5au3kqCVUD6tHJ6e8cFo9rZ/VWgwyFNcb2RrBfcHUaicnR9VGo96oVmFODbuq o9sepYKgbQ7kpiDxDDKVCQ6bGASLM90LZux59sdK5fHxkbUcRTUwq1qTiq3cVWBRDzpZDKyW0+Cr5Xztdp jL8zFWNOwE6Fxdu+1LN9jULMdlLkWsoWvFe19nD9l67aM0lQT4fswe7Qc95PMdWvhnNv4nMvSsNJb9a/xo YM87GCjqd8VZNoK32PdXbK0G//1EP+uNDWBoX3Wh3bGBu2RP3h+xDbbKVvelqbkEW1dXHct9dj08cWHY6U 9H7Bn8rZUY64/JaPVbrDtv6criK6gSMuBv/bziC0OGUAwMxbuznAkIxeHxfr0Of2uH8HkCn7X9o7P92hn5 Wt8HHtWPT/ZrJ439s9oijCPTndpABUj9DHllwdQty4AOIMDQzelTo75PP+Wn48Pgm65EX21bjb7/4WJHxy 78HtukS3F0Vw1/0TGKHo5wLYN0yy5AxX8/xb+fHu8/6qAhj24jb4GgcaytTJhL+9aZmnlc8JR7oo1gVpjL n/FEkx3L8n6uCF0JevAC3jXxnTI1vJAzZE/yCAFbdo0N28UeEKPcyWS4TIyBHJm51TbpxreF6T0ia3Wnms Vckn/zkGFvasvYfGAuQTapeL5/j6AVZHEyAYsMXbpjmRNseugB+KzcGtilcAAEnbtMpyl32lciJ36TB9zw WpZ63T6zz3wQejd/7gjdptjvD3deKoZ+26h/zGhNtdnYMTI7TOw9Ws73zL7ftO+V3xxM+ip64/S4oho60L wUjtn7lFjNQBA7R7CejBXk0hV2gHk/WAyEn7zKoC+1v2Z3j8R2dsf1sNuRB4oDKpMPcOADZM5+q5upNjBR E8WsKNpENyu+O3MrPewdNHvSQZU9PKVMWm0YQMLuHIBNPqvk8qcC5pVt5He7uodl+mtVwJWIW3nCin58en xArdOBNwb11w4moM56lozIV+1enowAs+eH/FMU5Ot+V8gYEkjk/Ig5tdq6RqXmb18Vmjd3jgzcOYizhJRw J6s9zujQbElgtuzA9iLXxqp+p6s5FizyxJNn9MFyIdD8z5SYRHTg/udTohOCzVivM9c7hnjlUXHwRQgwiQ GoY2tio13AH1JJ/uh3aJfOiX9HDAQMfYlBe+jPRGyQLwWVqUtVvGI82iFfk5hDkih+/fTYVtP4i0nausZ1 hVnz3Mampn5B2HDxxrhAA5FVaKGAG+bDepO/vEvwJCGN14OD0de0tFAYJhIsxpcsCNEKChZauKw2d3zYq4 AHe8jwcinA4jzd5uyLmNohDiWLUwXZWpqxBOUqK6NTZ7B1PcauN3vEznk+uY2z6hNTkE+5hIInAYVSXFdX Py6AKcOdzc+ZyxN6WPp/zBO8oZVvws+9madbbIy49tcF0UZuzLfG/qRp6Eut2iZDEsWwx8pSsiLIDXvjNW ZPs6apOI/AvgRzUqL9HsXO/6gPobDikWSpRHNO75Ji8O4dRMatqamSrBLyLHq4z4yJWQI5cPCd/oS8MYYO Y4qRDeuCWWCg5ej3uqkYfgcB1k176rnogHyv7SEhAyvNM5D++h66oePc6W3Abn9JEEXvfgjB9yHeJlB7EH L/j/wp6P8wULyxhG1oZD4ytJVwTQNSTaCN8jxC8RLj3VwPjPfRI3aGk52HovjnmZ6HyQd+9wLh/SzFomEQ Bz+P516ee4pzj72O7npBGnpsuR5NW2vAKV0xhrHWRGJ5+HkI4igN5VZfhOOjNJTC/DIBdluW0zZdTzEM5v I82sbZV0SF0h/wm/KgsIZi3rOS54CwhIi+9MVf5WZblDt9nqSQVhvrYqDeu2A8Z4pDTCNJEEFpJAlQNldH 5bf3Ra7JDbliVPjtTQEYVGKcf1dAT+XyFScJpea+Krvgdk8acp2OTLhWfFZZajdLjIovGVbLDdv93ppoel xXICgqMfmrzCR+HennPgu9IRX7xNXKrLm81C/gxRYWIgotmahyfBWkja6hIPv91VNdI6yn5qEcjsGX5oqj ryzLwIoZkT7qyQNREIV/SaXGttpf5RtObLe+FSVcFKRBvweq2mp3hMJzS98kftiRhR531RGaxeduwZJ7/K qTJ0d3+83CY+KmWSo6OGGNpTXMsbQJuyqVN6zSOpZVKmdapQ3ZVmkDxrUwjsHoSu6BuNHAgeu0OQm0rTMq LH5EzGXhK98ZNQUSDA8FsScDcYX1ri0Rnl7JfKffK0yFJEgScFIeSmX8s9QfiaCxQHW0MSX03vdBoacrNZ gIYzEEWSFWhK5s1EEQlIv4As/RbLaJYHMdIEHkumVkqgwfifT0u2D7wXGVlIHht0HhacPLhMIi3+sP5S/t XrP/pbD6UlWh6+212p/Jt7KbPYepTMjY73LtXinJHwrdQYcbCqUGz/OAuCJqjgKRvQuPszFcQV2NfwHI2j ZL7snZtqmT0Ez/A5NqHB9Sj7cVwibBP/wYq9/hlCzi3yVP8aZuiFZNdayKm9zUE0D2M/YAwYNuTV3Jw3YS vx3roYFq8pQJR38bPlRrAmdyTIAQfoIxrl8p9eHP+LJ3917COqgWd3ZUPRWODg+Pm9V6kxeqDVoHdXZcPa sf1epzsSxRwxFsa7vXhoA2WfQ010eItIFAw8DGYKzAadoPoV1CjaZ4ChvaMyAGm0Q4tNDepWgTsmlTLVPT vWCFFGfC27zMUT+4JgEJBK9gvQQfRP53O7mKHBgmYrGmOxg29cFncvSLUABb+xFWOBJ7LceakAzD7k4zBH ArfbrzKNYCngkNYiVglVqVrbNVtsZWKyAKNrnG4w3LxOjfun2nG3iH7Bx+wipscnM2tc81zeKJFRrZuWxs ZbMRAxMJ/yNEcaYRX7GYZZkQwLBb3aRVfAFUSC5LTy78ROvoJr5RHJfNijUYP88UbWxePPJC5GzlmRLebz YD2TiQJVXxdud+RIIaH/myj4KeZHzysgc9OxViLMhGFSEscFNRmDK3+oxIphR+snXbXjr9h0ot+4duF2WE L0DUXYdEBlFnJaF58DtQyErCyiwzOrP8QYYNPKmuamdiLj5lZXzFdRF3T1Kh19YEIwgjkG4+wG/LeQZ0QJ /vGKw7ZOJHNAYgl41sUKD6cwhmw2bWiOQbSK2WYmrUHqVWVFvBqnOa5qJ7x5ra6NHRPYxs7Ex06jpckvrt j9rtgHgdyFQ0mhD2bTZEqsrEAD+DCCkxGmfLaelPgDmPBS5D3RZZweXPpK4DROVnWuBxXgnbz2ETyU77Hz 7ll1PY3RbYxI8fJRuru7HE+qyH2OCsdt6ynz/NVYFMdeADuojhPLgETSBmd9dPAAd5fZB0xnff5PITZONO vyffgE16kk0MilFlQ4zjIcJsoggL2M2wATEs878mM0PgF5Xu7qjjiaWh+384j2gnBI3N80H4Cg6YhzMgSV P/gi4v0emnufKTGchPF6iK9qLuxKVMQPHI32igTB1DtIbp9cCMZrqzhEu5hM9upEhWPXOuYCqeTqDNzwBa QlrmJ0HuVFVB9O6mhvGcnPE8KP8CoZlTkbKGYy7nnmU96ivomh9fNIVBp/+NBLnp2CPqYxJhHdhT06M6Hv 3KiTkSdnyHD6GjACTWApbGwb9PdVIKd3BH9VSd9e5Exj48ClEjnxjUSg4Cc09ClO2FRbQIF8VJQLCxyCeD j5GxRpx00ljVDcSS', -- data1 'oS8ZcZM0BHcTAKRCpkQnPSdtOJDxJZhd0X0X8tKJ+4vZ9MGM8d5ieEPv3J15/1kJNg0CEqrwetE4OVQEUu f6wuYWk7ElJ5yTw3IiNx+6xx59gaGebubF81kSWVIWl27aypgyL+VS4pUF9WOIb3A1F2IsOjbzUipFXg7g yzqz0S1fNhMB2vxxa4tWil67hNP6wp11kMhPmqSSOoFvjSdjdn2Pt0y/jzbkUojOwjkYFnot8L/K7Ra5UB sNZLK2mCpfN8U8qMp/kdV0piYHIRh9kCXN0+MVeErWAwHCbsa5bT/G8dmtpL+b+WbVf6Iwz6QCz/kRUcc8 4zoD+NvM/m1m/3pmltqZLCv7l4nUTn48q9Pvdb4tNz1zUH/bn7/tz181zKOynhfrrZ5JWZw8WWSFpqb+RB 5HVD2j4hfmwkiSKKTpxZ3t5kjo5P67C5BPAyp+eZQIvSKbeKcYbpZRPN1A4pyIhX/nOxIFOajXmrdlKYCi ZiwhLQFRo95Vf9RrslX+5KzON88ax7Vqo3YmhG+FqNZOjw6PT67YJXiLye1cTdkWaErO8JKVQPnNuqWqAJ /N+GaYU8NgSKtf1zjgWkRwh45iunfYyZCAs41c0f6zT+79B99yrhrT3amtd7/rtqw46hg4EvGUinRqb1xr 6qhYJrohk5YIPHGDlTvOV2DLeX79m0Q4o8LEWA4uSDIcMn1WY2oC/ejASiMApnuyb5OTS48sNWnNmDngLG VaYmDQsZBj2RMmigHy3E98rwydFNmutlchvUs4RfnkZPNJN2mVxfL9XtfH+WscudhZyKGwmiwXw0Bx3UfL 0XIxhDVFL2GhmZ/dAK23PMFUnWfbw1o2MzKoWy2eIoMzCAsGJwpWl5JVCazWZk8VwTsv4l4VjTzdAPMFvc S/VhTDkMO7EDe4i+B8CVvzyoHbiPkkUjfqEauZX6ox11/Ed0YPW7x+kBfVDq6o969ykIkXF2ZXbJCul7KH o2KHgvVC3SxvFa+7fNnExd6batjViud2MDa7mbq295JRDRdc40nCcJQuh4t3Mq8hA28quSkVjZVuFT9Uvq Gt+WFvIcWpSYpxwvTWZvNa/GrFgT9WUuoVcynbUBnfPmQQ/lqiPhD7zRE/jGZuXr1l7raJbcN6RhI0wyBa aWOqMBrWeau46zqAZsnq1+xinUQP88Zy9Dp5vtfNXb5xVnFzUWLqsZm5XZ/vLxUvkgx5gRz6NjW8cJTHeZ 6ijmmha0mXlpeWFEqqPDcccvy1z7d5pY/3/cDu6hXsAXnO0H+IeE6i8x5CLOgcrzlRaCZV8C29E02rC75s ImIGUPCKwTUS6/QHLBpWlpbeVrmk+lLpJkXMssSL7QGYxnnxjncyP/65tfwVTRhVhBczyeLR7QbxeRFOSI tnWYa7XrhzuvxZhsCILhIXeoolV9XB83jysN/vSOmDbgqEKX+fusELkPRDkAUjntgjkFsgL4a+GF3J5yu3 QFligsJRIscPRxDNJDd1ZgqytyHSPzb2XpXty0TsEdvC6/zrXOHnvjZg1XuhRfFvp0NxS9sJE+IvD3oFcY k/jfxWJwogJ+sJudULYySZk7qyJHQEfijMtMwPowutCdA029KvsjQU273PESZtOpk8y/RHOXyJsHIdbGJs fWXx8J2RNBTE6OUx5fmVfIfNVq78YxMUl9GSp8k3yofy9P/9gdwNPBt9WttSsE0LtnlRIM5UGvjbnqzTTn aWP01uzwGtZWyyTomlfckCY785Q52KR9Ohy5ueQW+wo989I1rpqvuPI64p/PV1hT9IwGRLP/DtRqBv/JqT /FnHWlnI7Qk+ld2Ms8m654oth0T5AfSmgt/+aJh0YQ9UJrVb1pp6b6kgVNLR1Ebh1TFW1tSNRskcIkgf1x uFd8AcGPl0MWMKpIgiwB4OIaKU4MANUU63fyNsLk3+Ci9bOD1c4XFpakPaEg+LE7+l71+iniAR+8rvaBHx vQ5TOrP8TfEcdootRyXljRhUUfjcppHqkBM/C7CjX9rDa9nfhnnmLYH/rzHJvT4xkevaxxmWedHPq5Alta ikwFa69ovqaO7LZ3JUNuun86b+a5r42fs7ll3Gnx6vJgSzqth5StJ1saZiu2PLI4RFqyYvNZDVOJEZNYXB wF/1WPmkOnUcCPe3V4y3ktppt6HJWVPnTspeDa9umt4gTUCEITtfVDzw5kUpSVMJtQuP0b6xSaay8vUvz/ XM2sP/Zdrl/wFQSwcINx6K7vsRAABPcgAAUEsBAhQAFAAIAAgASj0TPzceiu77EQAAT3IAAAEAAAAAAAAA AAAAAAAAAAAAAHpQSwUGAAAAAAEAAQAvAAAAKhIAAAAA' ); UPDATE MGMT_PAF_TEXTUAL_DATA SET DATA_SIZE = 6368 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', 'SIDB', 'SIDBDP', 'SIDBDP_DESC', to_timestamp('2007-04-25 05:15:23.0', 'yyyy-mm-dd hh24:mi:ss.ff'), 'ORACLE', 'Y', 'paf_sidb_prov_procedure', l_data_guid ); COMMIT; END; END; /