http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fuser_stored_settings Oracle PL/SQL Tutorial/System Tables Data Dictionary/user stored settings - История изменений 2026-05-24T05:19:41Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/user_stored_settings&diff=3941&oldid=prev в 13:45, 26 мая 2010 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://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/user_stored_settings&diff=3942&oldid=prev Admin: 1 версия 2010-05-26T10:08:10Z <p>1 версия</p> <p><b>Новая страница</b></p><div>== Query user_stored_settings table==<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;<br /> SQL&gt; select uo.object_name,uo.object_type,uss.param_value<br /> 2 from user_stored_settings uss,user_objects uo<br /> 3 where uss.object_id =uo.object_id<br /> 4 and uss.param_name =&quot;plsql_compiler_flags&quot;<br /> 5 and uo.object_type in (&quot;PROCEDURE&quot;,&quot;FUNCTION&quot;);<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> DELETE_CUST PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DROP_IF_EXISTS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> WAIT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> TO_NUMBER_OR_NULL FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> TO_MMSDDSYYYY_OR_NULL FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> P1 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> P_RUN_INSERT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> ROW_AT_A_TIME_TEST PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> BULK_TEST PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> RUNDDL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> FLUSH PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CHITIME FUNCTION<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> FCREATE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DROPIT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> RULERSTR FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> VALUE_IN FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> CLOSECUR PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> TABCOUNT FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> SAVESTRINGTOFILE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PUT_BOOLEAN PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CREINDX PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> GET_LINE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> RECEIVE_MESSAGE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> IS_OVERDUE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> TRACEIT FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> SEND_MESSAGE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PRINTLN PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SHOWEMPS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PROCA PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> PROCB PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PROC0 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PROC1 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PROC2 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PROC3 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> GRPVAL FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> SHOW_FILE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> NEARESTDAY FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> FOPEN FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> ASSIGNDT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> ASSIGN PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> EMP_COUNT FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> ORG_PROC PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> EXT FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> F_CURSOR_EXP FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> P_PRINT_REPORT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SHOW_LINE PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> F_REPORT FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> F_CURSOR_EXP_COMPLEX FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> GETALLHIERARCHIES FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> F_CURSOR FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> CREATE_DYN_TABLE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> F_LINE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> SHOW_LINE2 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> F_GET_FORMATTED_ORG_NAME FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> P_NOCOPY PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> UPDATE_DYN_GLOBAL_BULK2 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> UPDATE_DYN_GLOBAL_BULK PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> P_DUMMY PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CREATE_DYN_TABLE2 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> UPDATE_DYN_FOR_ALL_ORDERS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> LOG_ERROR PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CREATE_DYN_FOR_ALL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> UPDATE_DYN_TABLE PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> UPDATE_DYN_GLOBAL2 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> UPDATE_DYN_GLOBAL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CREATE_ORDER PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CREATE_DYN_OBJ_FOR_ALL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> INSERT_DYN_OBJ_TABLE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> F_EQ FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> CREATE_DYN_OBJ_TABLE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DISPLAY_DYN_OBJ_FOR_REGION PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DISPLAY_DYN_OBJ_GLOBAL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> F_EQ1 FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> F_TABLE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> P_DISPLAYORGS_WITH_PARAM_FORM PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> F_TABLE_OBJ FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> F_TABLE_PLSQL_PIPELINED FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> F_TABLE_PLSQL2_PIPELINED FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> F_TABLE_OBJ_PIPELINED FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> P_DISPLAYORGS_WITH_PARAM PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> P_DISPLAYORGS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> P_TEST PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> P_SEND_EMAIL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> F_NOCOPY FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> X PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> SOME_FUNCTION FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> GET_DATA FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> TRACE_FILE_CONTENTS FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> DO_MOD PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> NO_MOD PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DO_INSERT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> BIND PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DONT_BIND PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DO_SOMETHING PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SIMULATION PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PUTLINE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> QSTRING FUNCTION<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> CREATE_A_TYPE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> CREATE_AN_INSTANCE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> GROK_ANYDATA PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> UPDATE_SALARY PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> AUDIT_CEO_COMP PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> AUTHORIZED_EMPS FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> AUTONFAIL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> FIRE_EM_ALL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> BETWNSTR FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> EXECDDL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> BOOKTITLE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> BULK_EXCEPTIONS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> COMPARE_INSERTING PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> COMPARE_FETCHING PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CANT_GO_THERE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CALCULATE_TOTALS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SHOW_PARAMETERS PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> POST_PROCESSED PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> TEST_CCFLAGS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> TEST_CCFLAGS_NEW PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CHECK_EXPRESSIONS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CHECK_STATIC PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> GET_EXPIRATION FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> PLW5001 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> VERY_CONFUSING PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PLW5004 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> NO_RETURN FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> PLW6002 FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> UPDNVAL FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> PLW7204 FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> SET_DEPT_CTX PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> GET_ENC_VAL FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> DYNPLSQL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> MOVE_BUFFER_TO_LOG PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> EXPIRATION_DATE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> RAISE_BY_LANGUAGE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> WORDCOUNT FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> TEST_FULLNAME PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> RUN_9AM_PROCEDURE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> SHOW_JAVA_SOURCE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> EDIT_DISTANCE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> GETERRORINFO PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> MY_TO_DATE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> SET_RANK PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SET_ALL_RANKS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> BUILD_SCHEDULE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> UPDATE_BILL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> ACCOUNT_BALANCE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> APPLY_BALANCE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> GEN_MULTCOLL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> GENTRIGREC PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> GENWHEN PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> WRAP_TEST PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> GIVE_BONUS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CREATE_WRAPPED_TEST PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> COMPILE_BY_VERSION PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> LOADARRAY PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CUST_LIST PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> ROW_AT_A_TIME PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> NROWS_AT_A_TIME PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> GATHER_MY_STATS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SEARCHED_CASE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> NEXT_BUSINESS_DAY FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> CREATE_CUST FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> RANDOM PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> B PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> A PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CUST_NAMES PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> MODTEST PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> COUNTERTEST PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PHONE_BOOK_LOAD PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CUSTOMER_DISCOUNT2 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> READIT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> GRANT_IT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> TEST_FUNC FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> LOAD_TEST PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CUSTOMER_DISCOUNT1 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> GET_CUSTOMER_NAME FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> MONTH_GENERATOR_PIPED FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> F1 FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> MONTH_GENERATOR FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> FIND_MY_DEPENDENCIES PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> GET_CUSTOMER FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> MONTH_GENERATOR_PIPE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> ORD_GENERATOR FUNCTION<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> ORD_GENERATOR_PIPED FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> CREATE_TABLE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CUST_DELETE_CHECK PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DELETE_ORDERS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SP_UTLFILE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> ADD_UP PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DELETE_FILE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> ADD_TWO FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> GET_EMPS FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> CHARTEST PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> P_ADD_PROD PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> P_ADD_ITEMS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> P_ADD_ORDERS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> P_ADD_EMPS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> MANUALJOIN PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SP_BFILE_READ PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SP_INT_LOB2 PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> SEARCH_TRIGS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SALARY_UPDATE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> EXEC_DDL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> TOTAL_CUSTOMER PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> ORDER_PROCESS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> RESET_SHIP_DATES PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> TEST_IF PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CALL_TEST_PROC PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> EE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DD PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CC PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> BB PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> AA PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> RECOMPILE_ALL_OBJECTS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> FORMAT_MONEY FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> STRING_LINE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CUSTOMER_CSZ FUNCTION<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> SELECT_EMP PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> FILL_DEPARTMENT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PIN_OBJECTS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CORE_PROCESS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> ADJUST_SALARY PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> SHOW_ORDERS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> MATH_CALC FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> ERROR_TEST1 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> ERROR_TEST2 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> TEST_EMPLOYEE_CURSORS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> VALIDATE_TITLE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> PAGEOPEN PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> LIST_DADS_TABLES PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> HOCKEY_PASS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SHOWVALS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> QUERY_FORM PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DO_QUERY PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> INSERT_PRODUCT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> BIZDAYS_BETWEEN FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> BIZDAYS_BETWN FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> DAYCOUNT FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> PLAY_WITH_FILES PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> NONAUTONOMOUS_INSERT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> GET_A_MESS_O_EMPS FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> AUTONOMOUS_INSERT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> AUTO_PROC PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SET_UP_REPORT_F FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> SET_UP_REPORT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> FUNC FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> CHILD PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PROC PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> AUTO_PROC2 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PARENT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> REGULAR_PROC PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> AUTO_PROC1 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> STATICEMPPROC PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SAL_CHECK PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> GET_ROW_CNTS FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> DYNEMPPROC PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> UPDATE_ROW FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> DBMS_SQL_SELECT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DUMP_QUERY PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DESC_QUERY PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DUMP_FIXED_WIDTH FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> NATIVE_DYNAMIC_SELECT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> DBMSSQL_NOARRAY PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DISPLAY_CUSTOMERS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> COUNT_EMP FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> DBMSSQL_ARRAY PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> NATIVE_DYNAMIC_NOARRAY PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> NATIVE_DYNAMIC_ARRAY PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> MY_FUNCTION FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> STR2TBL FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> MYFUNCTION FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> PRINT_TABLE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> INVOKER_RIGHTS_FUNCTION FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> PRED_FUNCTION FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> RLS_EXAMP FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> INVOKER_PROC PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DESC_TABLE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> EMP_DEPT_RPT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SHOW_USER_INFO PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> HOST PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> RUN_BY_JOBS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SEND_MAIL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> BACKGROUND_ALERT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> FAST_SEND_MAIL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> BACKGROUND_SEND_MAIL PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> ANALYZE_MY_TABLES PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SHOW_EMPS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> EMPS2FILE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> ENSURE_MINSAL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> UPDEMPS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> LOAD_A_FILE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CLEAN FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> UPDNUMVAL PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SALSTAT FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> TO_BLOB FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> TO_CLOB FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> PUT_LINE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SETTRIG PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> UPDCOUNT FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> FORWARD PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> MKPIPE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> TABLE_IS_ANALYZED FUNCTION<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> TEST_TRACE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> VALIDATE_STRUCTURE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> MYRAISE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DUMP_LONG PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> NUMBER_STRIPPER FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> EMP_REPORT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> FACT_ITERATIVE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> FACT_RECURSIVE FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> P2 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> P3 PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> REBUILD_INDEXES PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> LOAD_LOGS PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> CONVERT FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> SM PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PRINT_CLOB PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> PRINTLONGTEXT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SHOW_IOT_SPACE PROCEDURE<br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> INTERPRETED,NON_DEBUG<br /> MEASURE_USAGE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> SHOW_SPACE PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> DO_COMMIT PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> MYTIMEFUNCTION FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> GETNAME FUNCTION<br /> INTERPRETED,NON_DEBUG<br /> <br /> OBJECT_NAME OBJECT_TYPE<br /> ------------------------------ -------------------<br /> PARAM_VALUE<br /> ----------------------------------------------------------------------<br /> MYPROC PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> WEBPROC PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> WEBPROC_WITH_PARAM_FORM PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> WEBPROC_WITH_PARAM PROCEDURE<br /> INTERPRETED,NON_DEBUG<br /> <br /> 327 rows selected.&lt;/source&gt;</div> Admin