| Subject | Execute Statement & Row_Count in SP | 
|---|---|
| Author | constantijnw | 
| Post date | 2004-06-18T14:39:31Z | 
Hi,
In a SP I have the following lines:
.
.
EXECUTE STATEMENT
'UPDATE ATAB SET ' || UPDATECLAUSE || ' WHERE ' || WHERECLAUSE;
ROWSAFFECTED = ROW_COUNT;
.
.
The DML statement works fine but ROW_COUNT returns 0 even when a row has
been updated.
Doesn't EXECUTE STATEMENT set ROW_COUNT?
Constantijn
            In a SP I have the following lines:
.
.
EXECUTE STATEMENT
'UPDATE ATAB SET ' || UPDATECLAUSE || ' WHERE ' || WHERECLAUSE;
ROWSAFFECTED = ROW_COUNT;
.
.
The DML statement works fine but ROW_COUNT returns 0 even when a row has
been updated.
Doesn't EXECUTE STATEMENT set ROW_COUNT?
Constantijn