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 := 'FB939B71D27CFC4EE040538C96090321'; 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 'UEsDBBQACAAIAEc9Ez8AAAAAAAAAAAAAAAABAAAAeu1de3ObSBL/P5+CJblycmWD3rayse+QhGLlJKEDyU murorDaGyTRcAOyI/d8ne/Hh4SSCCBhGU7K+86QvPomenp7un5TQ/+9I/7iU7dImxrpkGdUgdFpnBAIUM1 x5pxTRJGw/bRycE/zj5Z2FTReIpRUPyUrjAFmlIxUhw0bjyc0oLINbs8TSGMTdwzx+iUth3ToinnwYJnTq IG2LzVSGWgTlPXU218Srcb9XK9cVxslY6b7WaF5wuVQrV80qzXCvVCuVSkKV2xnZE1Js2c0sVysXxcq9TL lVKhTFNjZKtYsxy3Q73vX0o83xR6A67/XW7xg67wXfZ6JUtCe/iVE3lIlpo0ZSgTlK4CTQGPDPuUvnEc6y PL3t3dMSZWVB0xqjlhLeWKtULD4sbwaOJvvS599ukGKWOE/cYUyxpqCA90xbky8aRt6pBn02e6Zkzvy6VD 91O+r1X8J02ZPVqWOnv+w0ZYQzZ8v7FIloI1Ww2+uXUULahhmzrJlm0oFf5+H34+qR3eacbYvLPLpU+s1+ X4rivXyHAaio0uPBGgz44O5/8VC0yJKTAgQqHHBILANcZSJvSZdYmnxupWBekCQfcIq0Q0ps4V522JqTCl 4kdpKvHwXGOqh37OYbTELySzvqLc4Tm605HjHA0U9TcFj6mmybxtMMUi/P+L+1kqpyrTafQgHVsgGUQW31 aZMjCgcChNDaqnqdi0H2wHTWzIOPmlytThtxibm5jqpZhXzkI7BUIKftfMXSB2wMVK7bBUgt9iBT6P4bN4 WK0fFuvksXQIgynVjg+Lx+XDenEN0ZFhTy3oC2imLxI2zS4UtR3lmugF2An67G9oMpaxaTp/Y/meBDkooY E7dJm2geWi87GyMXJnT8cmfUb+TWjbRs7UkpFxS5+9oeDn7VsKkoDtkwlYSUjXsGlMQBWoW9Ag5VJHtlsO CkHme7rbkrudhsiJ3+UBNzyXpX5PoA/pd3z/4s8DvtcSBWF48Mjq2mW59DEmdSnNQliPzTCQc2fi32Lzfo x/Y39gRPJYrXxSY1Vdgz6vLUd/+DUymgEvdqswnpgRJPYryABbebS6ELp32IEgdb7FZ4/ETnzG+bDXlQcK BmOYXODIKxDb+qVmLKWBvk0Ug1XGE81gvXXFZvvIOWr1paMCUzlxmZSuGpSE2TkCI1FnE/nDgjVgysnZtu Yg2f2WtmCqzqVukNVqJ7Ujd905cm5Ag8dHk6nuaHEyIjc6/SQZAWYvVvkCS/G50ONjqvgSuVhjQa2eXKOW 2u80MrWb2EYM7QTCcUJKuBOXHmZ0YLYkMFuWbwwp20KqdqWpCRbMrUN+Jg/UO9MG5+9/U2IPqSP7f79GMs EBDOXihdwbWCLvFIxOgwKTUAH1xpxY1HugH/SS/GhX1Hu3TfQ7RcPqJ0g09YH6c5a/WgrYqe2qOKvfWQFf o5SDLrn0tZOapS7TzyZp2xrXFK0mLRt5Nf1IId1GuXHBdTHT9MUtmDMftmv88U2EJxFpPB8cjb4tS4tbhp 4JFu1JFjjfGQWLWjmsDler9FlYwW5jVrmlgtl5+pStr2JqlywocZzKyNaNGUtIphmZ23QMW7dj7Hatz9i5 yCe7XC/c0xn5lNhRWElAoRTb1tSPK8pswp3820zkibsN/gvzBOU08jzWuWdb6VYbI67zbYW3kejzbTE/y3 0QpHYxT5dE0a0bZW23ZiVzXo23aH2ZNS0F3wH7IsxZEu23VGj3TwngCisOATAlF0B5ExWDN2/AM25PDZUA KJRjupv7WJ+YISUHGF1p95RzgyBDnyLKgnFBK1DRxNq1Zii6l0EKa4Y1dWzqiDwXP1B8DFUXZCD5pQ/UhV vPnl767PaGBF70+3dB8UPwt0mpD+By/1P+1c9/N1CcGwlZkEh/pN1UwrUxdNWAvrk8n5F4DPFuIQfqe+Qp Zk6TWSzl0l9kehIlr/CbxzdvVkM7e1hvK1jP52ILXSmwIw8QLwLurYbs0lfwW8gP9PUJ5otELhB9Tag6OV I5R7oFuk+fWcqVrNqyYsua4WBzPHXNU2r4NQJ5jhEYX0+S7LNPjoKvkdPVbMc/iLkxbcc9uBnDzGqKPvRT J2jhPGX4eQjGXxrKbUGUucFg2OFFF7SR6GhHzoEi8PzTzHLOHyl3HfBK/1BuFUZXjGtGcrB7BOSlg9Sfk9 bZjar1lexVpzDdRqZ6NgKGOae0g6eInqHJtn1n4jGhwobGzs5Znhv7v/KNZfb7wr9n//OwH6OJopFDP3mv B886EVcatp3wJOznIHYOsnTLty0dw3YUXScOQEvDWcfmT8l2RFR9Cg4T3oS3GmnYUDeaF02xOXJqMghxNp NI3NiE68gYwAq9QeVNqim26ujpKjZMU0eKEZLCL9x/+t2xYm1SV5K64H4I59LmlbsNMetwLzTsTBXd1fjN qm7CZKHT2qRFqLbpzPjc7bQ2aHOU2bzMu7uh5IvIMm3NMfED4dMmujenMMrFOs7pbTqmNllivs79rXSjWp hK/RLLNtKRCh575spgSx1oXJ4a2n3mymDNN68ctOxvaDZufNP6hG0bdZxUTN1o7MoV3VdmJRK7Oc2+ht1a Du6a6sYVObKFz7wCWRNDRL9Pke0EZusqAM1C1f1QOC/MgLEsRrFJOBxDyjIiuiYrIC4WiqW2gidzx9lLd9 OIwxLdsUKWBR+wvQanAemDG/AbKM+PsU/pd3+OFUdhwi734yyYkKtXCyd8tVKuVAulVpMvlAvVYy+YsFQt lhY8y2BPOxB5kf/3qCN1hrzcPOeb/5LkwTknRaMF15amZ11XzYllGsB1Cb5Ts2+k88CwjzCQkdhvY3NCML f3XqJqGqrivD9oBqVtVnCZS4VSBhhhmBSNBGocXWn30xB1mz04pKLciUre4yF1EKXQjlI4+PD4AXg51jCY KO0WJfT3oBUUmHUxlDJ5cIMqgaZiPERCPtkigYcISFRiiT6zbkgo6Q7ldQTdI3VKpuaAdMP7hlrz3ngmfW w2iZKPrCABTw0OBMMN7FoWhFq8IAC7x5onBnOezWzkYxpJueDFTvu7LA35wXpBCRUGObkEq0QQaq/CbIhM n+uBTE3GXc1AFwq2mU5fGnLdrtxwpbEj0h7YvKgGUQ/7kShV6ia4z3x/6AXjBMTncXqZKAEdck4gdPrDGS nfQGjQUe/M0310TEtumhhlIj+SeJEkhnjgWQUm2ENlG7gf6RsZeUQXV/KYKFOxcM15mURis7R9PhwOgFPi nFF/z16/K/XFbYhwUnModqMUgjEHOwl3WGzEoMF3386xERu9rck+3r3J9jCFTr8lfJX25ju9+U603BT0l/ rq+VzZrPiSOJxkNdy+q7e33Xvbvd52//e/e+OdxXiHzxrijHc9hfEOwNt0xntt6RdksGN3en9Nf5tLa7bD mMRjGklpd76NBssme03ZPC12LCj+Ai22YpPLaSAQwEx1TLrt2W/yr6YicsjsjkAmRzFy+VVY8nje+164j8 xtb8j9xnz8/TEPs358fHyytWX/++4seWP3lvyFuuEv3qrvwg1vZrXnCW743qTvTXpak+4653ubnh+00kph 0wPlA335zJN4r26nyQ07Ql8murgDs5zO5qVBSXzasL3TNdU9VqBISUq60SwSYbJDE+3Xcy87kwt5U2tLe8 ynmMr4KVy2syvKZbGxQHLYl7tCc0MYFXquOOoN6wM5WTX+P51BuwP2JtwBJiBm+1PO/KFZ+Vr1tJqLTV2H FuMVdyl0KU572ymmvN0RpeEsStN7l0WPjCA830mFNlXuPPRZAkXAiGRbCMOMef7KLlSzhSzdfFi2EiQcm9 wh2k5Rq4UMcHbgpSTikeECdLalXZakrutgkwCSQJSvFN3OhuBd8KIEFmJGYc7ITGR2AIo+57mOdN4ZkIaf zxoST6O7HhWM0ptp', -- data1 'LdPhJK7V6/TlASdJXwWxtUhmMS7uMfv095u8vOBveqRD4XrP5YIThSGRcHK3xQ0WOxiKkssokp0W9E5amh M/liw7sbgJ9iPMshOL8f8DgqPkDcBcZtwOJYhLKI4sq6RcyIOhuCwjflRLNmpfYE8lizx518hQEL/PqL7N RGVOwJ3NOJ4tB789btpEdMdRLBTivI7ZQuku2LtYNnlvRaSIblH+K0VyBJCrxTwDNsitw+RVdZZLP+/ywk Zm8TkmtWkaV9o1ccQW3aEtvaBSZt+1KfTbnc8r/FavAP1KPIKmyHME7uyOQNDm5uzIe3NeNlIejdi1MxQl v4FlXOrdD1MzduTXPb/wXyCsXcVsBHxIbUsNKGfYB7iRBsFePM5ihQu8Fg0QeWkg9CWebNLz8Ylv3QljsG 3lYUCpTD+5SFwQGZu3ta3EyxqClZME/s4IxS6V/OeOa16W8KDYpTOp9GuRyvy2DOs8VTf+OlZMf5iXroDC Zyt+StqgPOeus+kveyMxbBygondvLli/XUlqmjq5ZEBua1PIIBM/TpSYajqJWZz8pH4tzb5tKJZ9Yzqkmz MOkbt/shru8jLDg4r/gtRZRXWKsR/MzvrMCwFvYaRtHWIef3kzBn2r1lLYb5HvcZ1+p/95HQK3quAchUuS C2Oq66FJH3DttqajIVYM+wrhmL6nCalsCoPv3tbI3XHInX5bkNui0JMX4cL5MFLWWZYGc4pVJHtqAHuk7Z aDWJXHyAbKCMRrMlFCohN69yh5acvU+EOzqCNzmQAwx5E9cZHdq0dLp2IJG2IFqzeg2vIVzEmkop8RD0H7 LIlvMP2W0idD2pZ1jVyt9YlgUpu8JQAMkpbc6TXscpmF45mlGa4KP+msesOb3QZL5NAKvMIjMbsAlkhiBV xBRhvTh/WHpaRiTMt+RSvc4tyu7bH43LD4kz0Wv8fi91j8K8PidwMBu1iH7C6TezD4pYHB9T0Y/BOBwVyG ZTgGBn6lAPBPidpui3+//StAv4099LuHfncE/Tb30O8e+s0E/bZ+Iug3zxswVT7DDZgEnHc5+wUGUCffb/ Fpf0WXP03gdLWdOnAaJm9lwHQkP/9A6eSbbsFa6F+1ySdQ2ie2u0Dp3Xt5Pro4E+d8UMVaIYOdSEQV4wrQ Lw8LzOGe1HPe9EyNBT6Z8r1UWOxJtqfCueS+s5XvJ13Fmr8bMzvl3G53BYg8eXHlcqjv7KWWmxElL7RMIg p5LwTreWIAr1bM83UA8QDeUi79vEbpJQF4wZK35UpXyrDSxQB30aws0zPkxM/8UI6/nfq6Xjaw+Qr7aiGO nKSvvAG0MQMpZs56NAxnIZd+JUL0kqGLmR1+cuiiVskCXazv10uCLlZeF12DXNSqqeK9vJHzco/rj8AifS cPIFgtmZMCnH4h2itFjfyj12q1tNFrwqDXl4fCuoC12GLbxait3y6QF+myO49US3/8/ARRa6uX58RItQX+ hqkAQxkrEpX0CgLZVkx9Yjjb+lCyxDC2uGCyVOFr6UPoEsLYVgXQrQ3T3fp6fO04L6NXym71SnOzt3s3X+ hLFFlCqZEF3NoWzUoTIwctuiunPBq0uCEvRRi2mJnFp5KEkdjkc9C3rA7VDgI4NopPX7fS1/MS+nJ2oS8/ wVrPpV7rAylLE6K+ovATx6YnC+M+QD267JsGebWVcfUClvQ0OzZvVScd3geqX67eEGY2AllePSjxw9FAFp qVL7FQ0zz7qRR9bvdZzlLUGxR8uLJB7VV/vepPzLFsqpUfr0r/0072/srKdldWug2RigBEbLsaTcjhdkrK RjJ61YXmcb3UbNXJ8Ue5WOf5QsU1aYXiSbVSO27EnX+E/zjU4vlHV+BacoPrkmj9wLQtHYMkFXqGAIU8Ah Pa1fwjEVJT6gutXM4bCJ38jisvOktvJAr9CbzMtGI7FvrDeNkIes71AuNcknF/Oy0bbdDSxDsWo35DGPVb zDqdY1LSz96zpNcn5dWzgP7Ku0KkYNI1odQdiSf3GPxRPclRnClsUZGh4gfL/yN2uzj/evYAovmBak8xQD 30B/KgXKMx1fRiJLYEX5qpLpm7Jt5FsaOHWbN0+qc/C81g4MThiOvGvnZtC6vpEU1jORNhoLzfD1pLCuTF 2MQ9c0xOoEwDXOHkQ9I2J/biD0hJTjR0FQTc1Tt0b8F+xvZ9mPDf9Hv/Ia6XCVG1ce2xiaDZnInYVNEYNP Ls/1BLBwgFTZ/N9BEAAMaYAABQSwECFAAUAAgACABHPRM/BU2fzfQRAADGmAAAAQAAAAAAAAAAAAAAAAAA AAAAelBLBQYAAAAAAQABAC8AAAAjEgAAAAA=' ); UPDATE MGMT_PAF_TEXTUAL_DATA SET DATA_SIZE = 6360 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', 'MYJ2EECOMPANY_DEPLOY_ORACLE_SOFTWARE', 'MYJ2EECOMPANY_DEPLOY_ORACLE_SOFTWARE_DESC', to_timestamp('2011-08-19 07:42:14.203', 'yyyy-mm-dd hh24:mi:ss.ff'), 'ORACLE', 'Y', 'paf_cs_as_introduction', l_data_guid ); COMMIT; END; END; /