Kbase P132568: SQL: Error (7613) invoking ODBC API SQLPrepare function with parameterized SQL functions arguments
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/7/2008 |
|
Status: Unverified
SYMPTOM(s):
SQL: Error (7613) invoking ODBC API SQLPrepare function with parameterized SQL functions arguments
Bad parameter specification for the statement (7613)
If ANY argument of the following OpenEdge SQL CAST, CONVERT or ODBC compatible CONVERT functions is used as dynamic parameters, then the ODBC API SQLPrepare function fails with the above error.
Executing the ODBC API SQLPrepare Function in Microsoft ODBCTest Tool against any of the following SQL statements generates the above error:
SELECT T1.cVar FROM PUB.T1 WHERE iVar = CAST(? AS INTEGER)
SELECT T1.cVar FROM PUB.T1 WHERE cVar = CONVERT('CHAR', ?)
SELECT T1.cVar FROM PUB.T1 WHERE iVar = { fn CONVERT ( ? , SQL_INTEGER) }
FACT(s) (Environment):
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
Bug# OE00166174
FIX:
Upgrade to OpenEdge 10.1C01 or later