ORA-39082: compilation warnings

[yuji tokuyama]

Hi there. I'm not a native English speaker so, I apologize in advance for my English.
I've got some Oracle error and I cannot fix them by myself.
So, Could someone give me a advice, please.

These errors occuer when I import Oracle dump file.

    ORA-39082: Object type ALTER_FUNCTION:"BIOMART"."STRING_AGG" created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:"BIOMART"."TAB_TO_STRING" created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:"DEAPP"."NUMBER_PARSER" created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:"DEAPP"."TEXT_PARSER" created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:"I2B2DEMODATA"."SF_GET_VISIT" created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:"TM_CZ"."INSERT_ETL_JOB_STEP" created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:"TM_CZ"."INSERT_ETL_JOB_RUN" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"BIOMART_USER"."PATIENT_SUBSET2" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"DEAPP"."MICROARRAY_COMPARISON_QRY" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"DEAPP"."PROTEIN_COMPARISON_QRY" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"DEAPP"."PROTEIN_DBL_COMP_QRY" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"DEAPP"."RBM_COMPARISON_QRY" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"DEAPP"."RBM_DBL_COMP_QRY" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"I2B2DEMODATA"."PATIENT_SUBSET2" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"I2B2DEMODATA"."SETONT" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"I2B2METADATA"."ADD_ONTOLOGY_NODE" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."PARSE_DESIGN_FIELD" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."LOAD_KEGG_COMP_PATH_DATA" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."LOAD_JUB_TARGET_SUM_FROM_DB" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."LOAD_DISEASE_UID" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."LOAD_CENTCLIN_CONTENT_DATA" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_RBM_ZSCORE_CALC" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_PROTEIN_ZSCORE_CALC" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_PROCESS_RBM_DATA" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_PROCESS_RAW_DATA_EXTRNL" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_PROCESS_RAW_DATA" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_PROCESS_PROTEIN_DATA" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_PROCESS_MRNA_DATA" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_MRNA_ZSCORE_CALC" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_MRNA_DATA_EXTRNL_LT" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_LOAD_SAMPLE_DATA" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_LOAD_RBM_DATA" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_LOAD_PROTEIN_DATA" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_LOAD_FROM_RELEASE" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_LOAD_COMPOUND_METADATA" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_LOAD_ACROSS_TRIALS" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_CREATE_PATIENT_DIM" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_COPY_TO_RELEASE" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."I2B2_CLINICAL_DATA_EXTRNL_LT" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."EXEC_TEST_RUN" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."EXEC_TEST" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."CZ_AUDIT_EXAMPLE" created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:"TM_CZ"."CZX_START_AUDIT" created with compilation warnings
    ORA-39082: Object type VIEW:"TM_CZ"."ALL_TEST_DETAIL_VIEW" created with compilation warnings
    ORA-39082: Object type VIEW:"TM_CZ"."LAST_TEST_DETAIL_VIEW" created with compilation warnings
    ORA-39082: Object type VIEW:"TM_CZ"."ALL_TEST_SUMMARY_VIEW" created with compilation warnings
    ORA-39082: Object type VIEW:"TM_CZ"."LAST_TEST_SUMMARY_VIEW" created with compilation warnings
    ORA-39082: Object type TRIGGER:"I2B2PM"."PM_HIVE_PARAMS_INC" created with compilation warnings
    ORA-39082: Object type TRIGGER:"I2B2PM"."PM_HIVE_PARAMS_INC" created with compilation warnings


I tryed to re-compile with sqlplus for recovery but, I've got another errors...

    SQL> alter function "BIOMART"."STRING_AGG" compile;

    Warning: Function altered with compilation errors.

    SQL> show error
    Errors for FUNCTION "BIOMART"."STRING_AGG":

    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    0/0      PL/SQL: Compilation unit analysis terminated
    3/33     PLS-00201: identifier 'T_STRING_AGG' must be declared


    SQL> alter procedure "I2B2METADATA"."ADD_ONTOLOGY_NODE" compile;

    Warning: Procedure altered with compilation errors.

    SQL> show error
    Errors for PROCEDURE "I2B2METADATA"."ADD_ONTOLOGY_NODE":

    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    95/5     PL/SQL: SQL Statement ignored
    95/30    PL/SQL: ORA-00942: table or view does not exist


    SQL> alter procedure "DEAPP"."MICROARRAY_COMPARISON_QRY" compile;

    Warning: Procedure altered with compilation errors.

    SQL> show error
    Errors for PROCEDURE "DEAPP"."MICROARRAY_COMPARISON_QRY":

    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    41/1     PL/SQL: SQL Statement ignored
    46/28    PL/SQL: ORA-06575: Package or function TEXT_PARSER is in an
             invalid state

    50/1     PL/SQL: SQL Statement ignored
    51/12    PL/SQL: ORA-06575: Package or function TEXT_PARSER is in an
             invalid state

    55/1     PL/SQL: SQL Statement ignored
    57/44    PL/SQL: ORA-06575: Package or function TEXT_PARSER is in an
             invalid state

    81/4     PL/SQL: SQL Statement ignored
    104/35   PL/SQL: ORA-00904: "A"."PROBESET": invalid identifier
    109/8    PL/SQL: SQL Statement ignored
    133/35   PL/SQL: ORA-00904: "A"."PROBESET": invalid identifier
    144/4    PL/SQL: SQL Statement ignored
    168/35   PL/SQL: ORA-00904: "A"."PROBESET": invalid identifier
    188/8    PL/SQL: SQL Statement ignored
    213/35   PL/SQL: ORA-00904: "A"."PROBESET": invalid identifier


Could someone tell me how can I handle these errors please?
Systems are working So, Can I just ignore these erros or Do I need to fix them?
Do I need to prepare some file or setting before I start import dump file?

Thank you

[JAvitabile]

Can you please compile, in this order
"TM_CZ"."CZX_START_AUDIT"
"TM_CZ"."I2B2_MRNA_ZSCORE_CALC"
"TM_CZ"."I2B2_PROCESS_MRNA_DATA"
and post results?

Thanks

Jean Avitabile
Recombinant by Deloitte