How to call stored procedure on iodbc

Rails
1

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.

2

Got the solution!!!

Yipee!!!