locked
VB6 ODBC Oracle 11g [Microsoft][ODBC driver for Oracle]Syntax error or access violation RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

        We have VB6 application working fine with Oracle 10g. We are migrating to Oracle 11g and same SP execution getting following error:

    [Microsoft][ODBC driver for Oracle]Syntax error or access violation

     We have tried with ODBC driver update for latest but its not resolved the issue.

    Pls advise how to resove this issue.

    Note: following is the SP call:

    { call PK_LISTING.MOVE_FRONT(?, ?, ?, ?, ?, ?, ?, ?) }
    L_ID = 890083
    V_ID = 1
    SUBUNIT_ID = 6955141
    SUBUNIT_SEQ =
    P_CODE = 1
    L_SUP_TYPE = 1
    L_REF_NO = 1
    DELETE_REASON_CODE = 1
     [StoredProcedure.Execute2]

    Regards,

    Sathiyanarayanan Gopal

    • Moved by Jie Bao Thursday, August 9, 2012 4:17 PM (From:Visual Basic General)
    Monday, August 6, 2012 11:40 AM

All replies