Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query user_stored_settings table

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