1 Reply Latest reply on Jul 11, 2012 5:39 PM by alarzabal

    ORA-01008: not all variables bound

    alarzabal
      Hello folks,

      We started getting this error a lot after upgrading our Database from 11.2.0.1 to 11.2.0.2 running on an AIX 6.1 environment.

      Error: ORA-01008: not all variables bound

      The code has not changed.

      Any clues as to at least where do we start looking?

      Thank you!

      Alex.
        • 1. Re: ORA-01008: not all variables bound
          alarzabal
          Another error thrown by the same Pro*C code, but the code has not changed:

          Wed Jul 11 08:22:33 EDT 2012 - ORA-03113: end-of-file on communication channel
          Wed Jul 11 08:22:33 EDT 2012 - Process ID: 9833120
          Wed Jul 11 08:22:33 EDT 2012 - Session ID: 2037 Serial number: 1133
          Wed Jul 11 08:22:33 EDT 2012 -
          Wed Jul 11 08:22:33 EDT 2012 - WRN-ORACERR: Error occurred in file "smreval.pc" at line 10,470
          Wed Jul 11 08:22:33 EDT 2012 - WRN-ERRSTMT: Following statement was last statement parsed:
          Wed Jul 11 08:22:33 EDT 2012 - select SMRALVL_LEVL_CODE ,SMRALVL_TERM_CODE_EFF ,SMRALVL_CONNECTOR_MAX