Displaying 1 result from an estimated 1 matches for "sql_param_output".
2007 Apr 18
1
How to call stored procedure on iodbc
...dReturnCode = 0;
RETCODE returnVal;
char sqlString[500];
memset(sqlString,0,sizeof(sqlString));
HSTMT hstmt = ptrDB->GetHSTMT();
returnVal = SQLAllocStmt(ptrDB->GetHDBC(), &hstmt);
if (returnVal == SQL_SUCCESS)
{
returnVal = SQLBindParameter(hstmt, 1, SQL_PARAM_OUTPUT,
SQL_C_SLONG, SQL_INTEGER,
0,0, &returnCode,0, &bindReturnCode);
//strcpy(sqlString,"{call PI_ShBlobData (?, 0, 0, 0,
EMPTY_BLOB(), null)}");
returnVal = SQLExecDirectA(hstmt, (UCHAR*)sqlString,
SQL_NTS);
refPk = returnCode;
bRetVal...