Oracle PL/SQL Tutorial/System Tables Data Dictionary/user stored settings
Query user_stored_settings table
<source lang="sql">
SQL> 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.</source>
