Hi all, I am getting a problem in calling Stored Procedure from C++ application on macintosh using OpenLink.
Exact scenario is that my stored procedure takes 6 parameters out of which 1 parameter is out parameter and other 5 are input parameters.
So it uses 5 IN parameters as values for inserting a row in database and returns its max id as out parameter.
Code Snippet is given below :--
SWORD returnCode = 0; SDWORD bindReturnCode = 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 = true; ptrDB->CommitTrans(); }
SQLFreeStmt(hstmt, SQL_DROP);
Thanks for help in advance.