1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
// select query...
CString sz = "select count(*) from road.test";
st = ::OCIStmtPrepare( m_pStmt, m_pErr,
(text*) sz.GetBuffer( 0 ), sz.GetLength(),
OCI_NTV_SYNTAX, OCI_DEFAULT );
if ( st != OCI_SUCCESS && st != OCI_SUCCESS_WITH_INFO ) {
return false;
}
// ---> this one is ok
st = ::OCIStmtExecute( m_pService, m_pStmt, m_pErr, 0, 0, NULL, NULL, OCI_DEFAULT );
if ( st != OCI_SUCCESS && st != OCI_SUCCESS_WITH_INFO ) {
return false;
}
// update query
sz = "update road.test set col1 = 3";
st = ::OCIStmtPrepare( m_pStmt, m_pErr,
(text*) sz.GetBuffer( 0 ), sz.GetLength(),
OCI_NTV_SYNTAX, OCI_DEFAULT );
if ( st != OCI_SUCCESS && st != OCI_SUCCESS_WITH_INFO ) {
return false;
}
// ---> this one never returns....
st = ::OCIStmtExecute( m_pService, m_pStmt, m_pErr, 1, 0, NULL, NULL, OCI_DEFAULT );
if ( st != OCI_SUCCESS && st != OCI_SUCCESS_WITH_INFO ) {
return false;
} |
Partager