VB6 ODBC Oracle 11g [Microsoft] [Oracle的ODBC驱动程序]语法错误或访问冲突 [英] VB6 ODBC Oracle 11g [Microsoft][ODBC driver for Oracle]Syntax error or access violation

问题描述

   我们的VB6应用程序与Oracle 10g一起正常运行。我们正在迁移到Oracle 11g并且执行相同的SP会出现以下错误：

[Microsoft] [Oracle的ODBC驱动程序]语法错误或访问冲突

 我们已尝试使用ODBC驱动程序更新，但尚未解决此问题。

请告知如何解决此问题。

注意：以下是SP电话：

{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]

问候，

Sathiyanarayanan Gopal

解决方案

您可能想尝试像此链接这样的VB 6论坛
htt号码：？//www.vbforums.com/forumdisplay.php 1-视觉-基本-6和 - 早些时候

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

解决方案

You may want to try a VB 6 forum like this link http://www.vbforums.com/forumdisplay.php?1-Visual-Basic-6-and-Earlier

这篇关于VB6 ODBC Oracle 11g [Microsoft] [Oracle的ODBC驱动程序]语法错误或访问冲突的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！