Oracle Error PLS-00360: cursor declaration without body needs return type

Oracle Error Message

PLS-00360: cursor declaration without body needs return type

Reason for the Error

A cursor declaration lacks either a body (SELECT statement) or a return type. If you want to separate a cursor specification from its body, a return type must be supplied, as in CURSOR c1 RETURN emp%ROWTYPE;

Solution

Add a SELECT statement or return type to the cursor declaration.