Oracle Error PLW-05024: Do not use BULK COLLECT clause in a cursor declaration

Oracle Error Message

PLW-05024: Do not use BULK COLLECT clause in a cursor declaration

Reason for the Error

A BULK COLLECT clause was specified in a cursor declaration.

Solution

Remove the BULK COLLECT clause from the cursor declaration, moving it to the FETCH statement or statements, if appropriate.