ERROR | cursor declaration without body needs return type |
CAUSE | 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; |
ACTION | Add a SELECT statement or return type to the cursor declaration. |