From: "John Savill" <john@savilltech.com>
Newsgroups: comp.databases.oracle.misc
Subject: OCIStmtExecute return numbers
Date: Tue, 10 Oct 2000 20:54:03 +0100
Organization: UUNET WorldCom server (post doesn't reflect views of UUNET WorldCom
Lines: 26
Message-ID: <8rvs3h$9m1$1@lure.pipex.net>
NNTP-Posting-Host: userep43.uk.uudial.com
X-Trace: lure.pipex.net 971207601 9921 62.188.15.140 (10 Oct 2000 19:53:21 GMT)
X-Complaints-To: abuse@uk.uu.net
NNTP-Posting-Date: 10 Oct 2000 19:53:21 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400


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@savilltech.com