Reason:
A SELECT INTO statement results in more than one row qualifying for return. If an error occurs because the result table has more than one row, values might be assigned to the host variables. If values are assigned, the row that is the source of the values is undefined and not predictable.
The SQLSTATE that equates to this SQL return code is 21000.
Action:
To facilitate the return of multiple qualifying rows, use a cursor.
|
Copyright © 2014 CA.
All rights reserved.
|
|