Previous Topic: -502 - CURSOR ALREADY OPENNext Topic: -505 - ON-CLAUSE ERROR: x NOT ALLOWED


-504 - PLAN OPTION ERROR: error-string

Explanation

An error related to the use of plan options occurred. The error-string in the message identifies the specific error condition and should be self-explanatory.

The SQLSTATE that equates to this SQL return code is 53S31.

User Response

Correct the condition described by the error-string. For example, if the error-string was ISOLEVEL 'U' INVALID IN ANSI AND FIPS SQLMODES, it would indicate that you should change either the SQLMODE or the ISOLEVEL of the plan in question.