http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FFunction_Procedure_Packages%2FAlter_recompile 2026-04-04T12:00:46Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Function_Procedure_Packages/Alter_recompile&diff=4414&oldid=prev 2010-05-26T13:45:46Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Function_Procedure_Packages/Alter_recompile&diff=4415&oldid=prev 2010-05-26T10:11:54Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== alter procedure p compile and check the dba_ddl_locks again==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt; create or replace procedure p as begin null; end;<br /> 2 /<br /> SQL&gt;<br /> SQL&gt; exec p<br /> PL/SQL procedure successfully completed.<br /> SQL&gt;<br /> SQL&gt; select * from dba_ddl_locks;<br /> <br /> SESSION_ID OWNER NAME TYPE MODE_HELD MODE_REQU<br /> ---------- ------------------------------ ------------------------------ ---------------------------------------- --------- ---------<br /> 20 sqle NAMED_BLOCK Table/Procedure/Type Null None<br /> 20 SYS DICTIONARY_OBJ_OWNER Table/Procedure/Type Null None<br /> 20 SYS DBMS_STANDARD Table/Procedure/Type Null None<br /> 20 XDB DBMS_XDBZ0 Body Null None<br /> 20 sqle P_SPLIT Table/Procedure/Type Null None<br /> 20 sqle P Table/Procedure/Type Null None<br /> 20 SYS DBMS_SYS_SQL Table/Procedure/Type Null None<br /> 20 SYS DBMS_OUTPUT Body Null None<br /> 20 sqle UPDATE_EMP Table/Procedure/Type Null None<br /> 20 SYS PLITBLM Table/Procedure/Type Null None<br /> 20 sqle CHANGEPRICE Table/Procedure/Type Null None<br /> 20 SYS DICTIONARY_OBJ_TYPE Table/Procedure/Type Null None<br /> 20 SYS DBMS_UTILITY Table/Procedure/Type Null None<br /> 20 SYS DBMS_WARNING Table/Procedure/Type Null None<br /> 20 sqle AUTHORS_SEL Table/Procedure/Type Null None<br /> 20 sqle COMPUTE_DISCOUNTS Table/Procedure/Type Null None<br /> 20 SYS DATABASE 18 Null None<br /> 20 SYS DBMS_SQL Body Null None<br /> 20 SYS DBMS_OUTPUT Table/Procedure/Type Null None<br /> 20 sqle AUTHOR_SEL Table/Procedure/Type Null None<br /> 20 SYS DBMS_APPLICATION_INFO Table/Procedure/Type Null None<br /> 20 SYS STANDARD Body Null None<br /> 20 SYS AW_DROP_PROC Table/Procedure/Type Null None<br /> 20 SYS DBMS_WARNING Body Null None<br /> 20 sqle P_HELLOTO Table/Procedure/Type Null None<br /> 20 sqle MEASURE_USAGE Table/Procedure/Type Null None<br /> 20 sqle sqle 18 Null None<br /> 20 SYS DBMS_SQL Table/Procedure/Type Null None<br /> 20 sqle MY_FIRST_PROC Table/Procedure/Type Null None<br /> 20 sqle TEST_TIME Table/Procedure/Type Null None<br /> 20 SYS DBMS_ROWID Table/Procedure/Type Null None<br /> 20 sqle P_HELLO Table/Procedure/Type Null None<br /> 20 XDB DBMS_XDBZ0 Table/Procedure/Type Null None<br /> 20 SYS DBMS_UTILITY Body Null None<br /> 20 sqle EMP_CHANGE_S Table/Procedure/Type Null None<br /> 20 SYS DBMS_APPLICATION_INFO Body Null None<br /> 20 SYS DICTIONARY_OBJ_NAME Table/Procedure/Type Null None<br /> 20 SYS DBMS_ROWID Body Null None<br /> 20 sqle BIND_TEST Table/Procedure/Type Null None<br /> 20 SYS DBMS_SPACE Body Null None<br /> 20 sqle EMPLOYEE_COUNT Table/Procedure/Type Null None<br /> 40 SYS AQ$_ALERT_QT_E 10 Null None<br /> 40 SYS DBMS_HA_ALERTS_PRVT Body Null None<br /> 40 SYS DBMS_RCVMAN Table/Procedure/Type Null None<br /> 40 SYS DBMS_PRVT_TRACE Table/Procedure/Type Null None<br /> 40 SYS PLITBLM Table/Procedure/Type Null None<br /> 40 SYS PLITBLM Table/Procedure/Type Null None<br /> 40 SYS DBMS_HA_ALERTS_PRVT Table/Procedure/Type Null None<br /> 40 SYS DBMS_PRVT_TRACE Body Null None<br /> 40 SYS DBMS_APPLICATION_INFO Table/Procedure/Type Null None<br /> 40 SYS STANDARD Body Null None<br /> 40 SYS ALERT_QUE 10 Null None<br /> 40 SYS DBMS_APPLICATION_INFO Body Null None<br /> 40 SYS DBMS_BACKUP_RESTORE Body Null None<br /> 40 SYS ALERT_QUE_R 23 Null None<br /> 40 SYS DBMS_BACKUP_RESTORE Table/Procedure/Type Null None<br /> 40 SYS DBMS_RCVMAN Body Null None<br /> 41 SYS SCHEDULER$_INSTANCE_S Table/Procedure/Type Null None<br /> 58 rows selected.<br /> SQL&gt; alter procedure p compile;<br /> SP2-0805: Procedure altered with compilation warnings<br /> SQL&gt;<br /> SQL&gt; select * from dba_ddl_locks;<br /> <br /> SESSION_ID OWNER NAME TYPE MODE_HELD MODE_REQU<br /> ---------- ------------------------------ ------------------------------ ---------------------------------------- --------- ---------<br /> 20 sqle NAMED_BLOCK Table/Procedure/Type Null None<br /> 20 SYS DICTIONARY_OBJ_OWNER Table/Procedure/Type Null None<br /> 20 SYS DBMS_SYS_SQL Body Null None<br /> 20 XDB DBMS_XDBZ0 Body Null None<br /> 20 SYS DBMS_SYS_SQL Table/Procedure/Type Null None<br /> 20 SYS DBMS_OUTPUT Body Null None<br /> 20 sqle UPDATE_EMP Table/Procedure/Type Null None<br /> 20 SYS PLITBLM Table/Procedure/Type Null None<br /> 20 sqle CHANGEPRICE Table/Procedure/Type Null None<br /> 20 SYS DICTIONARY_OBJ_TYPE Table/Procedure/Type Null None<br /> 20 SYS DBMS_UTILITY Table/Procedure/Type Null None<br /> 20 SYS DBMS_WARNING Table/Procedure/Type Null None<br /> 20 sqle AUTHORS_SEL Table/Procedure/Type Null None<br /> 20 sqle COMPUTE_DISCOUNTS Table/Procedure/Type Null None<br /> 20 SYS DATABASE 18 Null None<br /> 20 SYS DBMS_SQL Body Null None<br /> 20 SYS DBMS_OUTPUT Table/Procedure/Type Null None<br /> 20 sqle AUTHOR_SEL Table/Procedure/Type Null None<br /> 20 SYS DBMS_APPLICATION_INFO Table/Procedure/Type Null None<br /> 20 SYS STANDARD Body Null None<br /> 20 SYS AW_DROP_PROC Table/Procedure/Type Null None<br /> 20 SYS DBMS_WARNING Body Null None<br /> 20 sqle P_HELLOTO Table/Procedure/Type Null None<br /> 20 sqle MEASURE_USAGE Table/Procedure/Type Null None<br /> 20 sqle sqle 18 Null None<br /> 20 SYS DBMS_SQL Table/Procedure/Type Null None<br /> 20 sqle MY_FIRST_PROC Table/Procedure/Type Null None<br /> 20 sqle TEST_TIME Table/Procedure/Type Null None<br /> 20 SYS DBMS_ROWID Table/Procedure/Type Null None<br /> 20 sqle P_HELLO Table/Procedure/Type Null None<br /> 20 XDB DBMS_XDBZ0 Table/Procedure/Type Null None<br /> 20 SYS DBMS_UTILITY Body Null None<br /> 20 sqle EMP_CHANGE_S Table/Procedure/Type Null None<br /> 20 SYS DBMS_SPACE Table/Procedure/Type Null None<br /> 20 SYS DBMS_APPLICATION_INFO Body Null None<br /> 20 SYS DICTIONARY_OBJ_NAME Table/Procedure/Type Null None<br /> 20 SYS DBMS_ROWID Body Null None<br /> 20 sqle BIND_TEST Table/Procedure/Type Null None<br /> 20 SYS DBMS_SPACE Body Null None<br /> 20 sqle EMPLOYEE_COUNT Table/Procedure/Type Null None<br /> 40 SYS AQ$_ALERT_QT_E 10 Null None<br /> 40 SYS DBMS_HA_ALERTS_PRVT Body Null None<br /> 40 SYS DBMS_RCVMAN Table/Procedure/Type Null None<br /> 40 SYS DBMS_PRVT_TRACE Table/Procedure/Type Null None<br /> 40 SYS PLITBLM Table/Procedure/Type Null None<br /> 40 SYS PLITBLM Table/Procedure/Type Null None<br /> 40 SYS DBMS_HA_ALERTS_PRVT Table/Procedure/Type Null None<br /> 40 SYS DBMS_PRVT_TRACE Body Null None<br /> 40 SYS DBMS_APPLICATION_INFO Table/Procedure/Type Null None<br /> 40 SYS STANDARD Body Null None<br /> 40 SYS ALERT_QUE 10 Null None<br /> 40 SYS DBMS_APPLICATION_INFO Body Null None<br /> 40 SYS DBMS_BACKUP_RESTORE Body Null None<br /> 40 SYS ALERT_QUE_R 23 Null None<br /> 40 SYS DBMS_BACKUP_RESTORE Table/Procedure/Type Null None<br /> 40 SYS DBMS_RCVMAN Body Null None<br /> 41 SYS SCHEDULER$_INSTANCE_S Table/Procedure/Type Null None<br /> 57 rows selected.&lt;/source&gt;<br /> <br /> <br /> <br /> == Recompile objects is to use the ALTER object type object name COMPILE command==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt; create or replace function getArea (i_rad NUMBER)<br /> 2 return NUMBER<br /> 3 is<br /> 4 begin<br /> 5 return 3.14*(i_rad**2);<br /> 6 end;<br /> 7 /<br /> Function created.<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; alter function getArea compile;<br /> Function altered.<br /> SQL&gt;<br /> SQL&gt; select status<br /> 2 from user_objects<br /> 3 where object_name = &quot;GETAREA&quot;;<br /> <br /> STATUS<br /> ----------<br /> VALID&lt;/source&gt;</div>

Admin