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