Previous Topic: Copy of DDB---316 - %s.%s OUTSIDE SCOPE OF JOINED TABLENext Topic: -317 (alternate version) - CURSOR REQUIRED ERROR: CURSOR REQUIRED FOR NON-DYNAMIC SELECT

SQL Codes › SQL Return Codes -1 through -999 › -317 - CURSOR cursor-name ERROR: MULTIPLE stmt-type STATEMENTS ATTEMPTED

-317 - CURSOR cursor-name ERROR: MULTIPLE stmt-type STATEMENTS ATTEMPTED

Explanation

Only one UPDATE statement and one DELETE statement may be coded on a single cursor. The stmt-type field in the message is either UPDATE or DELETE.

The SQLSTATE that equates to this SQL return code is 24S04.

User Response

Remove the extra UPDATE or DELETE statement.