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 := 'FA938C71C3755C4EF0FFFFFC96091221'; 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 'UEsDBBQACAAIAEc9Ez8AAAAAAAAAAAAAAAABAAAAeu1daXfaSNb+nl+hIT3HyRwbDHgjnXhGBmGrGwOvBH bSXzQylG2lhaSRRGx3H/77e0sbWkpCG3gJOZ2Oraq6dXWr6qm7VF19/vfjTKZ+IN2QVIX6Qu3Uq/s7FFIm 6lRS7vCD8ai7d7Lz79PPmq5O0HSuI7f6l8pBdb9CTXQkmmh69vSlMuDodo+pUEjXVf1SnaIvFcNUtQplPm nwM81TQ139IeHGQL1C3c2l6ZdKl241T9rH9Xbz+PCwfcB097v4T7t1tN+qNxr1CiWLhjnWpribL5V6s948 PjpoNQ8PG80KNUXGRJc002KI5ofc4Eqo79ebQocZ9gbfBJsngR90R9c0x8Bjvl2hFHGG0lSvUCAfxfhSuT dN7VOt9vDwUFV1cSKj6kSd1TTxtqb5Xomewo+q/vWyVzn9fI/EKdKdrkRNG0lIH8qieavqs64qQ5lROZUl Zf7YbOxa/wqPRwfOT5Lo/ahpE+/nvwykS8iA3+81XCTqkjFxf7PaiJLbwlBlXCwYUMv/+6P/55Oj3QdJma oPRrPxuWazHGIdXrKqibPKqXajz5WYSs77DfgrBNTwm3FoSl2I5vtG9aDaqH/i5zwDPx9VD3edkt1gjX/g wlZCvd0L9CAj09wbipM/RX1KtdXq+7NqvQ7//cP6t9FMVYc9u4TnugYDiafN+8Nqs7pf3d/l5wp1KU101X gyTDQzoODkH4fVFvytE0tjn9pP1Fsz1M8+JgV/G8lSdGcJSPHgaLfRgL/1A/j3GP6t7x62dust/GNjF16m cXS8Wz9u7sJSSSY6Voy5BrzAIrqyF7BRqYWqGqZ4h6cxLOnK6T/RbCroqmr+s8Zc8lCCYjp4QDdpO4hWXb 5rjTDvjPlUrZzi/8f0bSBzrglI+VE5fUfBn/fvKXgEYp/NANDguaSrygwpJvUDJrx4IyPDqgeVoPBDpdcR euwZR3PfhCE9uhD4/uWgslv5helf/b3DXHa4wWC0s6jJ0k2z8YnwNPJMQ7pMLFCQ+aDqfxLLvk//rH3XES 6rSc2To9pEloDnlfUqH38NvM2Q4XqH8D6EN4jlyy0AaNtLroQezdpwwLNfycVjjiUXXIwue8JQ1AG74ivs 2RWIvd9ISuQZrLeZqNTE6UxSavYWYNT6yNzr9Pm9/erBiSWkdM2gJozOHoBEqxYrnxqgQbUZX2xIJhKs39 JWTMVc6g5r0tHJ0Z61TeyZ97CCp3uzuWxKpDkinLH9uDkCwg43+Q32zYvBJUNo4szIcIvQslr7ior0z55l 6je2DwLtGMKkSYqlQ3ruF7QLWzzAluaAIWVoaCLdSpMYBLPa4D+zJ+oX1QA97b9zjIfUnvHfXwOFoKv5Sv VQ6T1skQ+ijr64FWa+CpN7daZRH4C+yyX+I91SH6w+0f+oCux+A75CfaT+9sqTZ0FtblhLvCY/aK5cg5Rd liz60smRNonSzzbTioJril7jto2yul5QSDZQaVKwNMI0vFgVS5ZDsc4X7wIyCczGi+He+Gt0tlh1Kt7Eqt gzC3TljBOLSnwtlj466NdgB/tB2OUiFbPLdJ29Jwm1hzcUkqQyijW3YDHJNG9mdU0QazHBFuvdE2dYTkaz tf9YySinWEZhJ4EFJRqGNPmUUCePdMrvM1YmltX6E8sElfTmZexzz7bTJYMRzX5N0DZidb4C4xPlYcB362 WqJKKs3Ysr2fJqlrwbF+g9KpqOqD+A+ALCiUzt95TP+qcGoAqLJvY18pYD5V1wGrx7B5pxd65MsAOFMlXL uCfqxFVcc6ijW+mRMu8RFMhzRGnwXtALNFR16U5SRNkuwJUlRZubBrWHf65/pBgCVcvJgMsbH6krq50xv3 HEbb8SaNEffnGr74K+jWt9BJX7P8KvTvkvQ9G855EGDyufKtZTLLUpsKoAb5bMPRILn+xCJdDeJk9VlzSr 4VoW/bDQ4yjZld8t3r2Lca84rt7KaX2/Wq82kx1AW+dfIeefI8UOuhXBbnf9YtgFmOzYS9/A6aFc92KI6K vybOvq5ALJGizoyqkm3goTQxANQVJMXZ3OLcxJ7VMN+DGnCBDVHnjj9LMp6nfI7EmG6QRC7lXDtAInUwAb SZRHztMZCsUzRucjQHR+JHQHnEAPhyOW4SxPDF8JMnIBFEHmnz04XP5IWeBu1/4u/hCrsqjcVXlTt0Iw9n PMUB9+wrxnaQeT+0LN3swWiADi14SppOfsNQ/Dc5hlSqZ2BoJxMoFnfY4qnmfaMB5UfYqp1Hwiry1HurRR v2bOoqPurLntqP9Uo66jmSjhMKPwKlf9dgBvJd0w/YO3HbuXOHb8YMy1GfJ+a+gTupTFt/mBmKgzTVVAEH ka40AL/NqRdDQxVf0pd+cdEHvWxliZxn6innSji/pTT51YqlVWMrcSjNJIZR4n8nz688xjIhTBPL4uRYnY zuPtPC5/HtO9njCiuXNmxAdObImyDPBrPtu0lRTDBB7ORAN1squwjgaMZbFh5fm1Dzpg1XbQ3+Sgn9Mj5p r+Rhz4O9FED+LTyCK++XEvuleUL/9sm81cn6CRM+2eWWd+rUNYbKu9yGmk2WOSBzHarnrSBcYL2Icb18u8 xmOun7vtmaSIr0WlO1NVGYmKt8cYY01WxelI5W9hNd783Fa2qYuKcYv0c1WesjPxDr1W/PCgL8+agMZjGN Z+4WEFQsOcuwiMnyk4UpgWNpryotIGZ3fGVetYI95E5ZEMMkLTHADg6Lg5SIXmrG3Xs4W0VsdJWYwIbJqG mXUC+3RuZZJrtkiiQeMj1HnnvHpv4LmAlKGqmzka52kmGhNTTtcwNHFgbfxG/9HvTUUtT1ue792q+uCCz9 +4d8Zlfd0rSTfnomz5wPM1zSPkAdvJ0yM0yzsyjnTZTo4+x6WAHmY+5zrgkKYamItcDSW8U+TVgJcUypHC kl5eYVh3KSaiYdLTqY4MI3f7PBOXt2y5wrg2OfjOOriaYz8w3f0gJyw/2PtbERITGdSIXK4U+UYXsJ6q5O gVt82ugSzb5rXguzhc6PPSp5NYCIQU9NDGUhulElqosTPqwlyRHjM3dsY7X2O3Z+cIT+7O87bH42bkVMCI d31zanHFiDhSvMllFzuNPZfCXFeKksiz5gu9gzMNCjUuIoAwiZxmoBNyLtZ6YN1bz2MFL2mUZo869PJuZU sK18UtdIdS0UFykLpY60KD5NAobZAcegUGyaFQwiA5lDIOEslet8jgLbGYrV4GGYeb4ozw+beqAD4VbZ/X wRPGyaLt8/IRfp9RDlUzzEseGt7UsL3C+XzC3uzIRiQyxzh0h90hMNstd05WNpwonu/YVJ6RCVIpB+KCNP PCXJBKUahzqGVW+5OolCqtgptCkEpRaUnKD83Ue+okd0P6Lj/sudf1cyJE3uZO70Md6eh/GGYKIJ1NBN8m ymui2RQYBbeb5pREsVcJEMn1KgEKqV8lRATMzFnetjcakvO2RcZNEZanN+mXMoHrAs2B8SytQ84sYN3bYt MNepAAZr4QAWC/WHtRL6imLI0FJ+FSbhCwrjvlJOItnjCRW/fepo+IkzzNznRT1bSqaOAEalVct+qFwINB dc+fHlOcpytXp8G531y9xrtmEVF3MpNnFQlHwqW/UGe43HJ8z3AIMnhLDPrS4B8cK52biIffKPSoYVezFT v/5W9/+w8fF770eYf7J8zhQfOou9/otJn95v7h8YmVPq9xWG+EYvBsf8TSPfYPRuBHzDBw3CpYhFnUgD1Z RvLwXjQQZYdJDczLVDTFqv8WCoGd430yOxNVmUqm81IgxU+iMv3gkIyYRItdatlbBKMXWAzBM4TOcYIhx3 DM/41Znh0xQvuCaf/OC8MLmg8lAFxVuxIYF2upWyPj/ea+AwhmzPW7ujrDUPDBfghvOhHNDzseTBg1e8lS vif2C80lnM5p71Z6', -- data1 'nPuoG7Ud//tHHYIgnp0ghW6Qws5HW0aWgiX9QDH87nTcCh6Lviezp98aDIN5FpWnQA7Hmn0vuIZ9vDUrvy NmhbKZQI9oMsfDsoNZsH9DnSUntnI5Vdt4Uxhr7gNkj+2Xyq0oG4gwr+op5pV/ylge6FQTJbIkYmvBxLiR FCtJpl3Te69qn76ESTSb9iQFXYm6UWX7/AifbT2zph/LVew76OF1FIy1L/D6S90Ffc70R3aOLpf4Mn1fJk pAB6cPGAAYeKQcqJOAUTsVivWjqWpCW9VRJvJjnuHwQ58MbFipuhGWbC/u5OsMvLlH0jn0k43ixWg0hPfn lq//r+zte3yfK0KE5tsjrhek4M4W96SA9Vq1AC5tYWpzMKXPFRr2QitDZRSjGmvDKLrfEbrs1/EwJVoF62 9xa4tbLxG3ao6aVQuonEU10Obr10Dt28RsvzO45rfaaDqYhxkjuM41oyy8j0yug6wQ75xF2GqiW0TfInoM ovszm5AQ/TAPooeCpEtEJ/l9o4juXqBOh+gra78gFCceMvopfQpHacHcf6ot1USJIHlsrTKRnHgJ4AUiuW jgD2nAHAABTqaYbRvX8f+lCcLJuKw3sA59Cs03j/DO8Dm3CBZl4P3x8fFJYcj/14t0Nvw0+JXsbDheG3hd MRzb/Zbkc0jfbAtvW3h7VfC2Hg325PVrsC/UJ/Gid4PN+CRaWXeCGJ/EVpPdQv0W6ldB/TKxCQno6ZRAr+ oR33PgXPliN7wNBIsjaO8uT1iWQ/zJw3Zv0GeEwZDh6BE76LsrNBdsJyN1Vhi0XiQAxUWB2Pnwm79ramxK MkgcSoGJRogFgGENf27IvmJJORTxAqCgAoU5BBoFYfksxcGcpNEKoO6KYU29OLpsj+GF0UBgvrZ74w4BCY LZb7It4esB9zvbP8eIzrRHA+5blHw4uUZGUOfaF+wVI4Rw0adVxHe0uwNqg1ccuTWAl9Tzwml5O5Y9S/5g hwIeb4+adZO2+pekxdn15DNoMUfwlqL25/FZ7EYfW+IlPLdT9/hK3JPvMFb43q5vuLwtb/nIvWHre7TMoe Thp3efncQATv6zIJ2qO26nwHGHWjiLTxiZx8PegO4I7cHlEEYFRjiyuIk1rDHKtUPFJdIhvWcnBUi5bI44 us93QfU7H/Q6AnsJ89UyCuzZhrlfbjDf1RtrJsG/HT8tZS7LFfzUzhc0pLt4/Y0cjgkMMikYXM1YQNyp3i O41uy8asIyGU4eXIMlBSVIgOk3A0OPsMitj9XMFVih1J4aJWDl5XHyA1r30iNcxGiFoj65B6AQMLYHGjoF LiYQXzqxw0Cuo0UsDdyxIEs4ZVSYQiRPUAL/KyRnyU0nyw2gBk+WpCEkpj2KfScvRwVJJu7lm9jW3gl4Um u3cEF+lfieEwwD3DC+U83fY81ZvOs6oNFNa69Gj2XERNHt73hfYugkhc+XxUuA8jROC6Y2rH9aH1amaHtW F1MzT4ocuA6ZHJRdU1HND8F6/ruEH32mSXh4IlYJWPnnVrq3Htu2FVZrQBLAOVWLLBovEB8JvUE7Tl1MOA OBvUjwMqI5ud/JqB1ivSukpPqPhbRTgN5GNEUnId/o2zCkJq5HF64Fll129yFRhotnsCDLXMH1lCsYr8tN ruW0qzmizybU2/zKrTnT5WdawTGsYp17TUZusShxsoMp++KElagj3EBDOq60s3lnfwfBOnuiYFXJkp0els LzlHJzxxbEjEYKs8hVf1xne+zxQn+FLAv0iuF4WN3ezLAFgb+sl2mSbeCAInkeu/7cSK6c3MQFftzt4u+V ehK5c4hnong57o0AOgH+6E6HY3g+zHQ4Md0iJ3mS8z6QtC4bYf6CHVpieDbUtnVEEhgu08gtMocTeqtPQg bpeejlwjNL83Tnku0LQ5rnrwdcJ0yNnO0vkfRKmimorVqW/XbE2erfWvx5/TIumvbBb0JiF/7MhW9yc2X7 V8MRF1or9sC5iSoyvnenw2J1i+7BlODoSz4GSQE0LMVSlIdgyM8M4g6+YQPZOjjF2PshhQeKsncyo8QzUy fNMi9o4c8lx++pXmllE3ZUmYOVOZ6nKrfSHVa4wspOQR3nIEssdWkgJZlFS4PHnyKTcJ8H1BF3JNuDfpc9 Dw5ypLjyrJEjnGN/yA2GIe0pEBXxvijzXFj6apWaHHvAOtfnlShLUzuBBHlBXiFduiWYHs5ZlIKr8jCD5W EdCXV9ACSU9Fd43iWUQx8pNMhU4E/Z7ik30wllB2cKDnnMPQkEMIzPHnqEiLskc87CNshF3UHEXTOuduWN ROZB5xNA6YtV+KzMZMTZFRdRXYquC6B6AVwCBNqb0pjzrzwv6Opu2BY0tFUZ7404e8/ywkzMPDhONw/CQx rHVzTKqoiaca/ayRNdCeGDAMLEzzIhpuY0/F3yBQcnc1130rwVjWitON57cpI+ohU+1BtzBjMmohUtfoMR rVaBw9KRQ3QhJzghOWasoxuEnTJcFVOzdGc3+VjsGsJUcalVt2Gq9GGqsAxfe5iKLhamKrZAVy3RmBhUoH zzy7HmzIGfaVnGsLrB2NNzOkOcsA/M4lLDPWnOEru6QWy4h1ThBYZ7Srj7sQbzMDHG44DWM16eePMRo7Vh bfkRo0QvAuGDSG8SvVcZuhmnCd8T8OfqQtT8n7LLThB/wi6OIJSVHHtxJjA59rJGd+FLib20y7yvTo69RE p/otiLq3EUVDQ6hWIuMVfV0sVc3NEjxFuCRW/FF7jmPXuNQaG1qQNXLDcaA4RiZ2GYrO/zoVmJkhUt30dF F2vfOH+aYAGTI1jguf09e92/+iOl22BAXDDA2wHXHwzoFvF5k0MGq7l/PSEDKHI+Ex4XNWjtpzDq24PhN2 FEc+fMiIehG9FsD9/edYMr5/SIuaa/CTzDXZG8YNmbl3+Fr1Uv7b7Pc0gj60XA1RvrOu8BWnIkf3xro/cC lczXAUl3uO0bvzvVnfAVX9sqB+u/qgUOeW/65iBB3NerL4KuukCYcI1v1e1BLfPVQcIrJNxejLlGSCAyLP VKoSxf25pVLJo28qOpu+/kxI+E5mtA02ZpsebnkMbrRdPQx/m2aLpeNI35VuBrQtPQhxjzoWnoy4uloKlD Oj4tROsgFZjaijkTXurR5HLJVddzhCW/K+3cFk8xO7h1WESEBLBNqPm89vDak/6Q3S1uugRrCce6WdZy3q uVOnG0fKMLRuz26w6plf3ljO7hoFHy8iHUXE9Sr94ZRwVcA+6i6R4Gn5dwtTK2r+ACJfacf30ep1ifQXHz zIiUDDeuUtbjJv3NH//6gx3ioyaBjruHZD0lgUx/QEoklj1DIaZTXkj8ih2+XBdyl+X4kRASnEWyK+mGuV rZTKAN68lynZHCzxiQsHtMyUWVkJLSo7rRpJTLS5CYrbj7j5itYGablBkg43Ohhb4TSvwkZyvDceDQZ9YX cY5xmhfavbH1I9E1viwv/AnPVqs0f92A7ThH+h3nM04O7j/a7zvmHN32Mrd+GfktgW1q6KLxhpVYL5QDTJ T7sYwWnXZWABD8Rv/R701FbeV8iGymxBrPfDMIWCLFI+F59o0EEyNtJPA8+yaCicVBMpSNcyFy5OypKk01 PJ0zqwXrvUCewuxY7Txa7iPWwMTsI3hwcl2hXxkqDG9IM1EBdcLed5Ljb62zZ12PJno0T3Ghre/ioebGbV zjc80q+1xbvsvz4jEvzjQ5cDn5RaSDKQOe99vHrUa702oeMV2m22KY/QNrOuzXTw4Pjo7PonfySHsn6Q57 XL0XcEnTznmBcW8JUZOD7yLOdJEtrzvNWflxg/g0e/reQAjgqYpEPQd3w2HyNdJx/2ww7neqy7Gr7zfr0b GrZu7puY4x+KfLut443MciN4ex567LZtPrKKOpGTplH/4OqTqdT8wrpGO4Sd7RlotleJ0uN0zRbz3ZxvqD MfO4wAWb+NRGtU4G', -- data2 'XIcUPh3J299koC5FRbwDFXlDWNzwsDi6NWNRud9vCWG1jbvC4Jq/jAJ0uPAtobKbtTwIJVhSxr2k3QN3mR XRDj2i7dsmHIt95qSDe9HVTx7GpNXvI7/Ix6DrtrFM3XQglYPN2N4y+uUZ7opNvctl59NPP6c88XxcG3+d M4t+Igh7nMTZFqkZSaC52Iiakl1AL1dNyaAEZH/ttEpAqVv1G7gystIFleIKCbzr375rx/4NNvxJd/uCyc dteq9VqtQyMo4VjpLdip20bowEXcnSg5xrI1EPRqjwhR8eLyX1wI2G5Jemgp8Nmd66de5uCp0byyZZ58ac xurcXuHb17mxpHLr3PbGxw2+fiM6z8vYZ0NdLPLyty49INRFNv7OvmHtzmmO08o4d8QYfh2sxve2NWTWbs j49ECOtvGlfcFc0sVthmRIInX1pk2Jl2YAlGf2bE2JjKYEk9mU8OsNr9iUeN4PMwxo6lk+zpBg02AULNmm SX01MkEXtcA5zqYJF76qC7E+R9YZCaOwUKY3qTLgP1eIAxk3L828YvizlxDRAMkkG1fAZ6xt5Za9fdMKxL S1rLaW1day2qBlZaFLSYZVhDCBeDZJYQLriku6tLdxom2c6Ccw7uj9zMadT23Z2nZvx7YD4CvXtKNT5zKJ V4QxGscZdqGyN2XXgUQ2Z9bF3exZPtfVCZrCJDn9f1BLBwiBIg0uFBkAAA/3AABQSwECFAAUAAgACABHPR M/gSINLhQZAAAP9wAAAQAAAAAAAAAAAAAAAAAAAAAAelBLBQYAAAAAAQABAC8AAABDGQAAAAA=' ); UPDATE MGMT_PAF_TEXTUAL_DATA SET DATA_SIZE = 8821 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', 'AS Provisioning', 'ASPROV_1013_DEPLOY_ORACLE_SOFTWARE', 'ASPROV_1013_DEPLOY_ORACLE_SOFTWARE_DESC', to_timestamp('2011-08-19 07:42:15.523', 'yyyy-mm-dd hh24:mi:ss.ff'), 'ORACLE', 'Y', 'paf_cs_as_introduction', l_data_guid ); COMMIT; END; END; /