oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01722: invalid number

Oracle Community | 974057 | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    which timezone DST Patch to apply in order to upgrade to 11.2.0.3 DB

    Oracle Community | 3 years ago | 974057
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01722: invalid number
  2. 0

    ORA 03113

    Oracle Community | 5 years ago | 911294
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-03113: end-of-file on communication channel
  3. 0

    Failure in Oracle 11.2.3.0 upgrade

    Oracle Community | 4 years ago | JamesW
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01078: failure in processing system parameters
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Upgrade from 10.2.0.5 to 11.2.0.4 fails

    Oracle Community | 1 year ago | goj
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-06550: line 5, column 38: PLS-00302: component 'JOB_TYPE_ID' must be declared ORA-06550: line 5, column 19: PL/SQL: Item ignored ORA-06550: line 6, column 40: PLS-00302: component 'MAJOR_VERSION' must be declared ORA-06550: line 6, column 21: PL/SQL: Item ignored ORA-06550: line 7, column 41: PLS-00302: component 'MINOR_VERSION1' must be declared ORA-06550: line 7, column 22: PL/SQL: Item ignored ORA-06550: line 8, column 41: PLS-00302: component 'MINOR_VERSION2' must be declared ORA-06550: line 8, column 22: PL/SQL: Item ignored ORA-06550: line 14, column 17: PLS-00302: component 'FIX_FLATTEN_STEPS' must be declared ORA-06550: line 14, column 1: PL/SQL: Statement ignored ORA-06550: line 15, column 51: PLS-00320: the declaration of the type of this expression is incomplete or
  6. 0

    error while installing oracle 10.2.0.1

    Oracle Community | 9 years ago | 577835
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12547: TNS:lost contact

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException

      ORA-01722: invalid number

      at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl()
    2. oracle.sysman.assistants
      StepContext$ModeRunner.run
      1. oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1658)
      2. oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:1008)
      3. oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:339)
      4. oracle.sysman.assistants.dbma.backend.component.ScriptDirective.processDirective(ScriptDirective.java:162)
      5. oracle.sysman.assistants.dbma.backend.component.SubComponent.executeSubStepImpl(SubComponent.java:679)
      6. oracle.sysman.assistants.dbma.backend.component.SubComponent.executeStepImpl(SubComponent.java:585)
      7. oracle.sysman.assistants.dbma.backend.component.Component.executeStepImpl(Component.java:317)
      8. oracle.sysman.assistants.dbma.backend.SummarizableStep.executeImpl(SummarizableStep.java:183)
      9. oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
      10. oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
      11. oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2708)
      11 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:637)
      1 frame