PLS-00360: cursor declaration without body needs return type

PLS-00360: 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.

No comments:

Post a Comment