Hi,
I am unable to bind an integer variable into a prepared statement without the
database later causing an SQL Error when I execute the prepared statement.Note:ODBC
Driver is in SQLMODE ORACLE.
The statement is "insert into table(integercolumn) values(?)"
The error israised on execution is:
ERROR: SQLExecute : SQL_ERROR - [SAP AG][SQLOD32 DLL]
[SAP DB]Error in assignment;-802 Invalid numeric input parameter value. (errcode -802,
sql state "22005")
The BindStatement is of the form:
ret = SQLBindParameter(m_stmt, 1, SQL_PARAM_INPUT,
SQL_C_SLONG,
SQL_INTEGER,
0, 0, (SQLPOINTER)*intpointer, 4, 0);
The column into which the data ultimately is written is of type INTEGER but appears as
FIXED 20,0 in SQLStudio.
Is there any known issue here or am I missing something?
Regards,
Ajit
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
