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

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.

User Posts for PLS-00360

Jan172017

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.

Jun12017

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