Re: OCIStmtExecute return numbers

John,
This should work for your first question:

ub4 nrows;
OCIAttrGet(stmthp,OCI_HTYPE_STMT,&nrows,0,OCI_ATTR_ROW_COUNT,errhp);

On Tue, 10 Oct 2000 20:54:03 +0100, "John Savill" <john_at_savilltech.com> wrote:

>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 - 19:35:50 CDT