0 Replies Latest reply: Aug 7, 2012 9:10 AM by 946880 RSS

    vb6 ODBC - Syntax error or access violation in oracle 11g migration

    946880
      Hi,

      We have VB6 application with Oracle 10g and the same is working fine.
      Now, we are migrating to Oracle 11g now and we have updated the odbc drivers too.

      { call M_FR(?, ?, ?, ?, ?, ?, ?, ?) }
      L_ID = 890083
      V_ID = 1
      SUB_ID = 6955141
      SUB_SEQ = 1
      P_CODE = 1
      L_SUP_TYPE = 1
      L_REF_NO = 1
      DELETE_REASON_CODE = 1

      When calling the above sp in oracle 11g getting error: [Microsoft][ODBC driver for Oracle]Syntax error or access violation.

      But user has all the right and no issue with access. Also no syntax error. In SQLplus the same is working fine.

      Kindly help us to resolve this issue.

      Regards,
      Sathiya