Oracle Pro*C EXEC SQL statement

Can someone please tell me what is wrong with the code listed below:

EXEC SQL UPDATE vpd_avail
set AVAIL_IND = 'Y', AVAIL_TIME = '20010926', TIME_STAMP = '20010926' where LOAD_DATE = '20010926'
and DATA_CATEGORY = 'TXN'
and TABLE_NM = 'txn_trans'
and REGION_NM = 'na1';

if ( sqlca.sqlcode < 0 ){
 printf("\n\nNO ROWS UPDATED FOR CATEGORY=%s TABLE=%s REGION=%s COMBINATION\n\n",
 data_category, table_nm, region_nm);
 return ( -1 );
}
return (0);

The sql runs perfectly from sqlplus but when I run the Pro*C exe I shows that the record has been updated but in fact it has not.

Thanks. Received on Wed Oct 10 2001 - 16:02:00 CDT