Oracle PL/SQL Tutorial/System Tables Data Dictionary/user stored settings — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
(нет различий)
|
Текущая версия на 10:08, 26 мая 2010
Query user_stored_settings table
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.