| 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