OCIStmtExecute return numbers

From: John Savill <john_at_savilltech.com>
Date: Tue, 10 Oct 2000 20:54:03 +0100
Message-ID: <8rvs3h$9m1$1@lure.pipex.net>

Hi,

I have an SQL statement which performs an update

checkerr(errhp, status=OCIStmtExecute(svchp, stmthp, errhp, (ub4) 1, (ub4) 0,

(CONST OCISnapshot *) 0, (OCISnapshot *) 0, (ub4) OCI_DEFAULT));

How can I tell how many rows were updated?

Also I have another SQL statement

sprintf(tempSQL, "UPDATE COMPLETED SET AUDIT_TRAIL='%s', TS_LASTCHANGE='%s' where MMS_REF='%d'",AUDIT_TRAIL,timeStamp,mmsRefNo);

and each time I try to run through OCI it seems incorrectly terminated string but if I take the SQL and run it manually it works fine!

Thanks,

John

john_at_savilltech.com Received on Tue Oct 10 2000 - 14:54:03 CDT