PLS-00360 cursor declaration without body needs return type

Translate this page

Oracle Database Error PLS-00360

PLS-00360 cursor declaration without body needs return type


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;


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

User Posts for PLS-00360


kathybruntYes string error occurs when the name given is wrong or some kind of issue buy an assignment online related to the name or alphabets in the code, because i have faced it when doing my projects. You have given simple answer to it.


Buy assignment online | FinestAssignmentsI don't believe it's conceivable to declare a cursor along these lines. In the event that a cursor is declared in a bundle particular, it must be characterized in the body of an indistinguishable bundle from in the finest-Assignments.

Post your own questions, answers and tips for PLS-00360

No registration required

CAPTCHA Image New word