Home » PL/SQL MCQs

When ROWTYPE_MISMATCH exception is raised?

125. When ROWTYPE_MISMATCH exception is raised?

1. When a member method is invoked on an object type, but its instance has not been initialized, this exception is raised.
2. Error in PL/SQL occurs when memory is exhausted or corrupt.
3. Cursors raise this exception when they seek values in variables of incompatible types.
4. None of the above

Answer: C) Cursors raise this exception when they seek values in variables of incompatible types.

Explanation:

Cursors raise the exception ROWTYPE_MISMATCH when they seek values in variables of incompatible types.