qt调用oracle存储过程,qt调用oracle存储过程,该怎么处理(3)

当前位置:我的异常网» QT开发 » qt调用oracle存储过程,该怎么处理

qt调用oracle存储过程,该怎么处理(3)

www.myexceptions.net  网友分享于：2013-03-27  浏览：221次

/*

* Call the Store Procedure which executes the Result Sets

*/

strcpy( (char *) pSqlStmt, "{CALL ODBCRefCur.EmpCurs(?)}");

rc = SQLExecDirect(hStmt, pSqlStmt, strlen((char *)pSqlStmt));

if (rc != SQL_SUCCESS)

{

DisplayError(SQL_HANDLE_STMT, hStmt, "SQLExecDirect");

}

/*

* Bind the Data

*/

rc = SQLBindCol( hStmt,1,SQL_C_CHAR,Data,sizeof(Data),&DataLen);

if (rc != SQL_SUCCESS)

{

DisplayError(SQL_HANDLE_STMT, hStmt, "SQLBindCol");

}

/*

* Get the data for Result Set 1

*/

printf( "\nEmployee Names\n\n");

while ( rc == SQL_SUCCESS )

{

rc = SQLFetch( hStmt );

if ( rc == SQL_SUCCESS )

{

printf("%s\n", Data);

}

else

{

if (rc != SQL_NO_DATA)

{

DisplayError(SQL_HANDLE_STMT, hStmt, "SQLFetch");

}

}

}

printf( "\nFirst Result Set - Hit Return to Continue\n");

charptr = gets ((char *)error);

/*

* Get the Next Result Set

*/

rc = SQLMoreResults( hStmt );

if (rc != SQL_SUCCESS)

{

DisplayError(SQL_HANDLE_STMT, hStmt, "SQLMoreResults");

}

/*

* Get the data for Result Set 2

*/

printf( "\nManagers\n\n");

while ( rc == SQL_SUCCESS )

{

rc = SQLFetch( hStmt );

if ( rc == SQL_SUCCESS )

{

printf("%s\n", Data);

}

else

{

if (rc != SQL_NO_DATA)

{

DisplayError(SQL_HANDLE_STMT, hStmt, "SQLFetch");

}

}

}

printf( "\nSecond Result Set - Hit Return to Continue\n");

charptr = gets ((char *)error);

/*

* Should Be No More Results Sets

*/

rc = SQLMoreResults( hStmt );

if (rc != SQL_NO_DATA)

{

DisplayError(SQL_HANDLE_STMT, hStmt, "SQLMoreResults");

}

/*

* Drop the Package

*/

strcpy( (char *) pSqlStmt, "DROP PACKAGE ODBCRefCur");

rc = SQLExecDirect(hStmt, pSqlStmt, strlen((char *)pSqlStmt));

/*

* Free handles close connections to the database

*/

SQLFreeHandle( SQL_HANDLE_STMT, hStmt );

SQLDisconnect( hDbc );

SQLFreeHandle( SQL_HANDLE_DBC, hDbc );

SQLFreeHandle( SQL_HANDLE_ENV, hEnv );

printf( "\nAll Done - Hit Return to Exit\n");

charptr = gets ((char *)error);

return(0);

}

/*

* Display Error Messages

*/

void DisplayError( SWORD HandleType, SQLHANDLE hHandle, char *Module )

{

SQLCHAR MessageText[255];

SQLCHAR SQLState[80];

SQLRETURN rc=SQL_SUCCESS;

long NativeError;

SWORD RetLen;

SQLCHAR error[25];

char *charptr;

rc =

SQLGetDiagRec(HandleType,hHandle,1,SQLState,&NativeError,MessageText,255,&RetLen);

printf( "Failure Calling %s\n", Module );

if (rc == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO)

{

printf( "\t\t\t State: %s\n", SQLState);

printf( "\t\t\t Native Error: %d\n", NativeError );

printf( "\t\t\t Error Message: %s\n", MessageText );

}

printf( "\nHit Return to Exit\n");

charptr = gets ((char *)error);

exit(1);

}

我的异常网推荐解决方案：oracle存储过程,http://www.myexceptions.net/oracle-develop/177537.html

文章评论