none
ORA-01008: not all variables bound

    Вопрос

  •  

    Hello Everyone,

                                I’m trying to update my Target where the available value of each record is not equal to the Source records. But I’m getting this error.

    The code is below.

     

    UPDATE "ADMINDB"."BED_VISIT"

    SET "ADMIT_DATE" = ?,

    "ADMIT_ELIG" = ?,

    "ADMIT_LOCATION" = ?,

    "ADMIT_TIME" = ?,

    "ADMIT_TYPE" = ?,

    "AVAILABILITY_CDE" = ?,

    "BED_ARR_DATE" = ?,

    "BED_ARR_TIME" = ?,

    "BED_CLASS" = ?,

    "BED_CLASS_DATE" = ?,

    "BED_NO" = ?,

    "BED_OUT_REASON" = ?,

    "BED_READINESS" = ?,

    "BED_SPECIALTY" = ?,

    "CHIEF_COMPLAINT" = ?,

    "CONFIDENTIAL" = ?,

    "DIS_DATE_EST" = ?,

    "DOCTOR_CODE" = ?,

    "F_SOUNDEX" = ?,

    "HOSP_BED_NO" = ?,

    "HOSP_CODE" = ?,

    "IN_OUT_DATE" = ?,

    "IN_OUT_STATUS" = ?,

    "INPUT_BY" = ?,

    "INPUT_DATE" = ?,

    "INPUT_TIME" = ?,

    "ISOLATION_CODE" = ?,

    "LENGTH_STAY_E" = ?,

    "NO_OF_BEDS" = ?,

    "NON_DIS_REASON" = ?,

    "NURSE_STATION" = ?,

    "ORIG_DIS_DATE" = ?,

    "OUTSIDE_REF" = ?,

    "PAT_ACC_FLAG" = ?,

    "PHONE_EXT" = ?,

    "PROB_SPECIALTY" = ?,

    "REFER_DEPT" = ?,

    "REFER_DOC" = ?,

    "REFER_SOURCE" = ?,

    "SMOKER_FLAG" = ?,

    "SPEC_TRAN_DATE" = ?

    WHERE "PATNO" = ?

    AND "ADMIT_ELIG" != ?

    AND "ADMIT_LOCATION" != ?

    AND "ADMIT_TIME" != ?

    AND "ADMIT_TYPE" != ?

    AND "AVAILABILITY_CDE" != ?

    AND "BED_ARR_DATE" != ?

    AND "BED_ARR_TIME" != ?

    AND "BED_CLASS" != ?

    AND "BED_CLASS_DATE" != ?

    AND "BED_NO" != ?

    AND "BED_OUT_REASON" != ?

    AND "BED_READINESS" != ?

    AND "BED_SPECIALTY" != ?

    AND "CHIEF_COMPLAINT" != ?

    AND "CONFIDENTIAL" != ?

    AND "DIS_DATE_EST" != ?

    AND "DOCTOR_CODE" != ?

    AND "F_SOUNDEX" != ?

    AND "HOSP_BED_NO" != ?

    AND "HOSP_CODE" != ?

    AND "IN_OUT_DATE" != ?

    AND "IN_OUT_STATUS" != ?

    AND "INPUT_BY" != ?

    AND "INPUT_DATE" != ?

    AND "INPUT_TIME" != ?

    AND "ISOLATION_CODE" != ?

    AND "LENGTH_STAY_E" != ?

    AND "NO_OF_BEDS" != ?

    AND "NON_DIS_REASON" != ?

    AND "NURSE_STATION" != ?

    AND "ORIG_DIS_DATE" != ?

    AND "OUTSIDE_REF" != ?

    AND "PAT_ACC_FLAG" != ?

    AND "PHONE_EXT" != ?

    AND "PROB_SPECIALTY" != ?

    AND "REFER_DEPT" != ?

    AND "REFER_DOC" != ?

    AND "REFER_SOURCE" != ?

    AND "SMOKER_FLAG" != ?

    AND "SPEC_TRAN_DATE" != ?

     

     

     

    The error:

     

    [OLE DB Command [20874]] Error: An OLE DB error has occurred. Error code: 0x80040E10. An OLE DB record is available.  Source: "OraOLEDB"  Hresult: 0x80040E10  Description: "ORA-01008: not all variables bound".

     

    Please help me in finding the solution out.  

    25 августа 2007 г. 8:27

Все ответы

  • Hello Sheikh Mohammed,

     

    It appears as if not all of the parameters in your UPDATE are bound to upstream columns, or perhaps one of the binds is failing.   I'd suggest troubleshooting this a little more to ensure that each of the parameters are correctly mapped to source columns, and if they are, to determine which column(s) are failing.

     

    Try creating a table with an identical schema as ADMINDB.BED_VISIT, and create an OLE DB Command that maps to it.  Assuming it fails, try removing columns from both your test table and the OLE DB Command until it succeeds, and then determine what is special about the particular column(s) that are causing the failure.  That will probably yield more clues as to both the problem and the solution.  Once you have the specifics, post back here and I'm sure there will be more ideas about how you can work through the issue.

     

    -David

     

     

     

    28 августа 2007 г. 17:38
  • Hi Sheikh Mohammed,

    I am also phasing same error can you please help on this issue.

    Regards,

    Praveen C


    Regards, Praveen

    29 августа 2012 г. 13:33